For Oracle professionals who are going after the Oracle PL/SQL Programmer Licensed Associate accreditation, there are 2 examinations that will certainly satisfy the PL/SQL need: “1Z0-147: Program with PL/SQL” and the more recent variation: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a fair quantity of complication amongst prospects seeking certification over whether they should take one examination, or the other, or both. The intent of this post is to help describe the two tests, their resemblances and also differences, as well as why you might take one over the various other.
One thing must be explained from the beginning: there is never ever a factor to take both examinations. Unlike the DBA track, Oracle PL/SQL accreditations are not tied to the database launch. You do not end up being licensed in release X of Oracle PL/SQL and afterwards have a demand to take upgrade examinations. Because either of these 2 examinations will please the OCA-level PL/SQL demand, passing the various other would certainly offer no certification advantage. That stated, you need to decide which of both tests to seek. The 1Z0-147 test is a number of years older than 1Z0-144. Unless there is a details reason that taking the older test will profit you, your far better alternative is to go with the 11G version of the exam. Up until Oracle retires 1Z0-147, nevertheless, the choice is your own.
Both examinations have a great deal of commonality between them. This makes good sense as they are for basically the same subject. What is surprising is the number of distinctions that exist in between both. 1Z0-144 is not merely a remake of the earlier examination with brand-new PL/SQL features from variations 10G as well as 11G tacked on. There is an entirely different feel to the test and also SQL Course the subjects covered. There are several sections that do not exist in 1Z0-147 which cover attributes that did not exist in 9i. Nonetheless, the majority of the new sections in 1Z0-144 cover core topics of PL/SQL shows that perhaps should have been in the earlier examination. Several of the sorts of details covered in 1Z0-144 but not 1Z0-147 consist of:
The benefits of making use of PL/SQL
Configuring fundamentals, including variables, conventions, qualities, as well as lexical systems
Use SQL functions in PL/SQL
Implied vs. specific information conversion
Use labels, indentation, as well as whitespace to make even more legible code
Using DML in PL/SQL
The use of control structures as well as Loopholes
Using arrows and cursor characteristics
Making use of the FOR UPDATE provision
PL/SQL Style factors to consider
Compound information kinds
MASS SQL procedures
PL/SQL compiler changes
The variety of topics covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller sized. However, the very first 3 are shocking thinking about the noticable change to PL/SQL basics in the 11G examination:
Opportunities needed to execute treatments
Parameter settings and also DEFAULT values
Specification passing approaches– by reference vs. by value
A much larger focus on triggers
A lot more recommendations to client-side PL/SQL (1Z0-144 largely neglects client-side).
Much more concentrate on PL/SQL dependences and also invalidations.
Huge objects as well as the use of the DBMS_LOB bundle.
If you wind up pursuing 1Z0-147, make sure to examine utilizing the Oracle 9i paperwork. Capabilities that were added to PL/SQL in 10G or 11G will not be on that examination. Having actually looked into the subjects for both tests, I take into consideration 1Z0-144 to be the better exam from the perspective of the information evaluated. The subject matter is a much better mix of what is necessary for an entry-level PL/SQL programmer to recognize. New designers studying for this test will come out with an extra rounded and complete understanding of PL/SQL principles. Whichever examination you go after, be sure to study each of the exam topics detailed on the Oracle Education and learning website prior to setting up the examination. All the best on the examination.