For Oracle experts who are pursuing the Oracle PL/SQL Programmer Qualified Associate qualification, there are two exams that will certainly please the PL/SQL need: “1Z0-147: Program with PL/SQL” as well as the newer variation: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a reasonable amount of complication amongst candidates seeking accreditation over whether they should take one examination, or the various other, or both. The intent of this short article is to help describe the two examinations, their similarities and differences, as well as why you might take one over the various other.
Something needs to be made clear from the outset: there is never ever a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL qualifications are not connected to the database release. You do not come to be licensed in launch X of Oracle PL/SQL and then have a requirement to take upgrade tests. Due to the fact that either of these 2 tests will please the OCA-level PL/SQL demand, passing the other would give no accreditation benefit. That stated, you must make a decision which of both tests to pursue. The 1Z0-147 examination is numerous years older than 1Z0-144. Unless there is a specific reason that taking the older test will profit you, your better alternative is to choose the 11G version of the test. Until Oracle retires 1Z0-147, nonetheless, the selection is your own.
Both examinations have a good deal of commonality between them. This makes good sense as they are for basically the exact same subject. What is unusual is the variety of distinctions that exist between both. 1Z0-144 is not simply a remake of the earlier examination with brand-new PL/SQL functions from variations 10G and 11G tacked on. There is a totally various feeling to the test and the subjects covered. There are numerous sections that do not exist in 1Z0-147 which cover features that did not exist in 9i. Nevertheless, most SQL London of the brand-new areas in 1Z0-144 cover core subjects of PL/SQL programming that probably should have remained in the earlier examination. Several of the types of information covered in 1Z0-144 however not 1Z0-147 include:
The advantages of using PL/SQL
Programming fundamentals, consisting of variables, conventions, features, and also lexical devices
Use of SQL functions in PL/SQL
Implicit vs. explicit information conversion
Use of labels, impression, and also whitespace to make even more understandable code
Making use of DML in PL/SQL
Making use of control frameworks and Loopholes
The use of cursors and cursor attributes
The use of the FOR UPDATE stipulation
Exemption Handling
PL/SQL Style factors to consider
Compound information types
Autonomous transactions
BULK SQL procedures
PL/SQL compiler modifications
The number of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller sized. Nonetheless, the first 3 are surprising taking into consideration the obvious shift to PL/SQL principles in the 11G test:
Benefits called for to execute treatments
Specification settings as well as DEFAULT values
Specification passing approaches– by referral vs. by worth
A much larger concentrate on triggers
Extra recommendations to client-side PL/SQL (1Z0-144 largely neglects client-side).
A lot more concentrate on PL/SQL dependencies and also invalidations.
Big items and using the DBMS_LOB bundle.
If you wind up seeking 1Z0-147, be sure to study using the Oracle 9i paperwork. Capacities that were contributed to PL/SQL in 10G or 11G will not get on that test. Having actually investigated the topics for both examinations, I take into consideration 1Z0-144 to be the better exam from the perspective of the information examined. The topic is a far better mix of what is very important for an entry-level PL/SQL designer to understand. New designers examining for this examination will come out with an extra spherical as well as complete expertise of PL/SQL principles. Whichever exam you go after, make sure to study each of the examination subjects noted on the Oracle Education website before arranging the exam. All the best on the examination.