For Oracle specialists that are pursuing the Oracle PL/SQL Designer Qualified Associate qualification, there are two examinations that will please the PL/SQL need: “1Z0-147: Program with PL/SQL” as well as the newer version: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a fair quantity of confusion among candidates seeking qualification over whether they should take one examination, or the various other, or both. The intent of this write-up is to help describe the two tests, their similarities and also differences, and why you could take one over the other.
One thing should be explained from the outset: there is never ever a reason to take both tests. Unlike the DBA track, Oracle PL/SQL certifications are not connected to the database release. You do not come to be licensed in release X of Oracle PL/SQL and after that have a demand to take upgrade examinations. Due to the fact that either of these two tests will certainly please the OCA-level PL/SQL requirement, passing the various other would offer no accreditation benefit. That claimed, you must determine which of both tests to seek. The 1Z0-147 examination is several years older than 1Z0-144. Unless there is a certain reason that taking the older test will profit you, your far better choice is to select the 11G version of the examination. Till Oracle retires 1Z0-147, nevertheless, the selection is yours.
Both examinations have a great deal of commonality between them. This makes sense as they are for basically the very same topic. What is surprising is the variety of distinctions that exist in between both. 1Z0-144 is not just a remake of the earlier examination with new PL/SQL features from versions 10G and 11G added. There is a completely different feel to the examination and the topics SQL Course covered. There are several sections that do not exist in 1Z0-147 which cover attributes that did not exist in 9i. However, most of the new areas in 1Z0-144 cover core topics of PL/SQL shows that arguably need to have remained in the earlier examination. Several of the sorts of information covered in 1Z0-144 yet not 1Z0-147 include:
The advantages of utilizing PL/SQL
Configuring essentials, consisting of variables, conventions, features, as well as lexical units
Use SQL functions in PL/SQL
Implicit vs. explicit data conversion
Use of tags, indentation, and also whitespace to make more legible code
The use of DML in PL/SQL
The use of control frameworks as well as Loops
Making use of arrows and arrow characteristics
The use of the FOR UPDATE stipulation
Exception Handling
PL/SQL Design factors to consider
Compound information types
Independent deals
BULK SQL operations
PL/SQL compiler adjustments
The variety of topics covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller sized. Nevertheless, the very first three are surprising taking into consideration the obvious change to PL/SQL basics in the 11G examination:
Benefits required to implement procedures
Criterion modes and also DEFAULT values
Criterion passing approaches– by recommendation vs. by value
A much bigger focus on triggers
Much more references to client-side PL/SQL (1Z0-144 mostly neglects client-side).
A lot more focus on PL/SQL reliances and also invalidations.
Huge items and using the DBMS_LOB plan.
If you end up pursuing 1Z0-147, make sure to study making use of the Oracle 9i documents. Capacities that were contributed to PL/SQL in 10G or 11G will certainly not be on that test. Having investigated the subjects for both examinations, I think about 1Z0-144 to be the much better exam from the viewpoint of the details evaluated. The subject is a far better mix of what is necessary for an entry-level PL/SQL designer to recognize. New developers studying for this test will bring out an extra spherical and also full understanding of PL/SQL basics. Whichever exam you pursue, make sure to study each of the test subjects detailed on the Oracle Education site before arranging the test. Best of luck on the test.