For Oracle specialists that are pursuing the Oracle PL/SQL Programmer Certified Associate certification, there are two exams that will please the PL/SQL need: “1Z0-147: Program with PL/SQL” and the more recent variation: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a fair quantity of confusion amongst prospects seeking qualification over whether they must take one examination, or the various other, or both. The intent of this post is to aid explain the two examinations, their similarities as well as differences, and why you might take one over the various other.
Something ought to be explained from the beginning: there is never ever a factor to take both examinations. Unlike the DBA track, Oracle PL/SQL qualifications are not tied to the data source launch. You do not end up being accredited in release X of Oracle PL/SQL and afterwards have a need to take upgrade tests. Due to the fact that either of these two tests will satisfy the OCA-level PL/SQL requirement, passing the other would certainly supply no certification advantage. That claimed, you have to make a decision which of the two tests to go after. The 1Z0-147 test is several years older than 1Z0-144. Unless there is a specific factor that taking the older examination will certainly profit you, your better choice is to choose the 11G variation of the exam. Up until Oracle retires 1Z0-147, however, the choice is your own.
Both examinations have a large amount of commonality between them. This makes good sense as they are for basically the exact same topic. What is unexpected is the number of differences that exist between the two. 1Z0-144 is not simply a remake of the earlier examination with brand-new PL/SQL functions from variations 10G as well as 11G tacked on. There is an entirely different feeling SQL Course London to the examination and also the topics covered. There are numerous sections that do not exist in 1Z0-147 which cover features that did not exist in 9i. Nonetheless, the majority of the new areas in 1Z0-144 cover core subjects of PL/SQL programming that perhaps should have remained in the earlier examination. A few of the types of info covered in 1Z0-144 yet not 1Z0-147 include:
The benefits of using PL/SQL
Setting basics, consisting of variables, conventions, attributes, and also lexical systems
Use of SQL functions in PL/SQL
Implied vs. specific information conversion
Use tags, impression, as well as whitespace to make even more readable code
Using DML in PL/SQL
The use of control structures and Loops
Making use of cursors as well as arrow attributes
Making use of the FOR UPDATE condition
PL/SQL Style factors to consider
Composite information kinds
BULK SQL procedures
PL/SQL compiler adjustments
The variety of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller. Nonetheless, the initial three are unusual considering the noticable shift to PL/SQL fundamentals in the 11G test:
Advantages called for to implement procedures
Parameter settings and also DEFAULT values
Specification passing methods– by reference vs. by value
A much larger focus on triggers
A lot more referrals to client-side PL/SQL (1Z0-144 mostly neglects client-side).
Extra concentrate on PL/SQL dependencies and invalidations.
Huge items as well as making use of the DBMS_LOB package.
If you wind up pursuing 1Z0-147, be sure to research utilizing the Oracle 9i documentation. Capacities that were added to PL/SQL in 10G or 11G will not be on that examination. Having actually looked into the subjects for both examinations, I take into consideration 1Z0-144 to be the better test from the standpoint of the details tested. The subject matter is a better mix of what is essential for an entry-level PL/SQL programmer to know. New developers researching for this exam will certainly bring out an extra spherical and also full understanding of PL/SQL fundamentals. Whichever exam you pursue, make certain to research each of the exam topics provided on the Oracle Education and learning site prior to setting up the exam. All the best on the test.