For Oracle specialists that are seeking the Oracle PL/SQL Developer Qualified Associate certification, there are 2 exams that will satisfy the PL/SQL need: “1Z0-147: Program with PL/SQL” and the newer variation: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a reasonable quantity of complication amongst candidates looking for qualification over whether they need to take one examination, or the other, or both. The intent of this post is to assist explain both examinations, their resemblances and differences, as well as why you could take one over the various other.
One thing should be explained from the start: there is never ever a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL accreditations are not linked to the database release. You do not come to be certified in launch X of Oracle PL/SQL and afterwards have a requirement to take upgrade exams. Due to the fact that either of these 2 examinations will please the OCA-level PL/SQL need, passing the other would supply no qualification SQL Course London benefit. That claimed, you need to make a decision which of the two examinations to seek. The 1Z0-147 test is a number of years older than 1Z0-144. Unless there is a details factor that taking the older test will profit you, your much better option is to select the 11G variation of the examination. Till Oracle retires 1Z0-147, nevertheless, the selection is yours.
The two examinations have a large amount of commonality in between them. This makes good sense as they are for essentially the exact same subject. What is shocking is the variety of distinctions that exist between both. 1Z0-144 is not merely a remake of the earlier examination with new PL/SQL features from versions 10G and 11G added. There is a totally different feel to the test and also the subjects covered. There are numerous areas 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 topics of PL/SQL programming that perhaps should have remained in the earlier examination. A few of the types of details covered in 1Z0-144 yet not 1Z0-147 include:
The advantages of making use of PL/SQL
Setting essentials, consisting of variables, conventions, characteristics, and lexical systems
Use SQL features in PL/SQL
Implied vs. specific data conversion
Use of labels, indentation, and also whitespace to make even more readable code
The use of DML in PL/SQL
The use of control frameworks and Loops
The use of arrows and also cursor features
Using the FOR UPDATE clause
Exception Handling
PL/SQL Style factors to consider
Composite data types
Autonomous transactions
BULK SQL operations
PL/SQL compiler modifications
The number of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller sized. However, the very first 3 are shocking thinking about the pronounced shift to PL/SQL principles in the 11G examination:
Advantages required to carry out treatments
Criterion modes and DEFAULT values
Criterion passing techniques– by recommendation vs. by value
A much bigger focus on triggers
A lot more references to client-side PL/SQL (1Z0-144 mostly disregards client-side).
Much more focus on PL/SQL reliances and invalidations.
Huge things and also using the DBMS_LOB plan.
If you end up pursuing 1Z0-147, be sure to research making use of the Oracle 9i documents. Abilities that were contributed to PL/SQL in 10G or 11G will not be on that test. Having investigated the topics for both tests, I consider 1Z0-144 to be the much better test from the point ofview of the info examined. The topic is a much better mix of what is very important for an entry-level PL/SQL programmer to recognize. New designers studying for this exam will certainly bring out a more spherical as well as full expertise of PL/SQL principles. Whichever examination you seek, make certain to study each of the test subjects listed on the Oracle Education and learning site before setting up the exam. Good luck on the test.