For Oracle specialists who are pursuing the Oracle PL/SQL Developer Certified Associate qualification, there are 2 examinations that will please the PL/SQL need: “1Z0-147: Program with PL/SQL” and also the more recent version: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a reasonable amount of complication amongst prospects looking for accreditation over whether they should take one examination, or the other, or both. The intent of this article is to help clarify the two tests, their similarities and distinctions, and why you could take one over the various other.
One point needs to be made clear from the outset: there is never a factor to take both tests. Unlike the DBA track, Oracle PL/SQL certifications are not linked to the data source launch. You do not end up being licensed in launch X of Oracle PL/SQL and then have a need to take upgrade tests. Due to the fact that either of these 2 tests will satisfy the OCA-level PL/SQL demand, passing the other would provide no qualification benefit. That said, you need to decide which of both tests to pursue. The 1Z0-147 examination is a number of years older than 1Z0-144. Unless there is a particular reason that taking the older test will certainly profit you, your far better alternative is to go with the 11G variation of the exam. Until Oracle retires 1Z0-147, nonetheless, the selection is your own.
Both examinations have a good deal of commonality in between them. This makes good sense as they are for essentially the same topic. What is shocking is the variety of differences that exist in between both. 1Z0-144 is not just a remake of the earlier test with new PL/SQL functions from variations 10G and 11G tacked on. There is a completely various feel to the examination and also the topics SQL London covered. There are a number of areas that do not exist in 1Z0-147 which cover functions that did not exist in 9i. Nonetheless, the majority of the new areas in 1Z0-144 cover core subjects of PL/SQL programs that arguably should have remained in the earlier examination. Some of the types of information covered in 1Z0-144 but not 1Z0-147 include:
The advantages of utilizing PL/SQL
Setting basics, consisting of variables, conventions, characteristics, as well as lexical systems
Use SQL functions in PL/SQL
Implicit vs. explicit data conversion
Use of labels, indentation, and also whitespace to make even more legible code
The use of DML in PL/SQL
Using control frameworks and also Loopholes
Using cursors as well as arrow attributes
Making use of the FOR UPDATE clause
PL/SQL Layout factors to consider
Composite data types
MASS SQL operations
PL/SQL compiler adjustments
The number of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller. Nevertheless, the first three are shocking considering the obvious shift to PL/SQL principles in the 11G test:
Advantages needed to implement procedures
Parameter settings and also DEFAULT worths
Criterion passing approaches– by recommendation vs. by worth
A much larger focus on triggers
A lot more referrals to client-side PL/SQL (1Z0-144 mostly overlooks client-side).
More focus on PL/SQL dependencies and also invalidations.
Large items and the use of the DBMS_LOB plan.
If you end up seeking 1Z0-147, make sure to research utilizing the Oracle 9i paperwork. Abilities that were included in PL/SQL in 10G or 11G will not be on that examination. Having actually researched the topics for both tests, I take into consideration 1Z0-144 to be the much better examination from the perspective of the information examined. The topic is a much better mix of what is essential for an entry-level PL/SQL developer to understand. New designers examining for this test will certainly come out with a much more spherical and also full knowledge of PL/SQL basics. Whichever examination you pursue, be sure to examine each of the examination topics noted on the Oracle Education and learning website prior to scheduling the exam. Best of luck on the examination.