For Oracle professionals who are pursuing the Oracle PL/SQL Programmer Qualified Associate certification, there are two tests that will satisfy the PL/SQL need: “1Z0-147: Program with PL/SQL” and also the more recent variation: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a fair quantity of confusion amongst candidates seeking certification over whether they must take one examination, or the other, or both. The intent of this post is to assist clarify both tests, their resemblances and differences, and also why you might take one over the other.
One point should be explained from the outset: there is never a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL certifications are not connected to the database launch. You do not end up being accredited in launch X of Oracle PL/SQL and afterwards have a need to take upgrade exams. Due to the fact that either of these 2 examinations will satisfy the OCA-level PL/SQL need, passing the various other would certainly supply no qualification advantage. That said, you must determine which of both examinations to pursue. The 1Z0-147 examination is numerous years older than 1Z0-144. Unless there is a certain reason that taking the older test will certainly profit you, your much better option is to opt for the 11G variation of the examination. Till Oracle retires 1Z0-147, nonetheless, the choice is your own.
Both tests have a great deal of commonality in between them. This makes good sense as they are for essentially the exact same topic. What is surprising is the number of distinctions that exist in between both. 1Z0-144 is not merely a remake of the earlier test with new PL/SQL functions from variations 10G as well as 11G tacked on. There is a totally various feeling to the examination and the subjects covered. There are a number of sections SQL Course London that do not exist in 1Z0-147 which cover functions that did not exist in 9i. However, the majority of the brand-new areas in 1Z0-144 cover core topics of PL/SQL shows that arguably ought to have remained in the earlier test. A few of the sorts of details covered in 1Z0-144 however not 1Z0-147 include:
The advantages of utilizing PL/SQL
Programming basics, consisting of variables, conventions, characteristics, as well as lexical systems
Use of SQL features in PL/SQL
Implicit vs. specific data conversion
Use tags, indentation, and whitespace to make more legible code
The use of DML in PL/SQL
The use of control frameworks and Loopholes
Making use of cursors and also arrow qualities
The use of the FOR UPDATE stipulation
PL/SQL Style factors to consider
Compound data types
MASS SQL operations
PL/SQL compiler changes
The number of topics covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller. However, the first three are unexpected thinking about the pronounced shift to PL/SQL principles in the 11G test:
Privileges required to perform treatments
Criterion modes and DEFAULT worths
Specification passing techniques– by recommendation vs. by value
A much larger focus on triggers
A lot more references to client-side PL/SQL (1Z0-144 mostly overlooks client-side).
More focus on PL/SQL dependences and also invalidations.
Large items and also the use of the DBMS_LOB package.
If you wind up seeking 1Z0-147, make certain to study using the Oracle 9i paperwork. Capacities that were included in PL/SQL in 10G or 11G will certainly not be on that examination. Having investigated the subjects for both tests, I consider 1Z0-144 to be the far better examination from the perspective of the details examined. The subject is a better mix of what is important for an entry-level PL/SQL designer to know. New developers studying for this examination will certainly come out with an extra rounded and full knowledge of PL/SQL principles. Whichever test you seek, be sure to study each of the examination topics provided on the Oracle Education website before arranging the exam. Good luck on the examination.