Oracle PL/SQL Developer Certification: 1Z0-147 or 1Z0-144?

For Oracle pros who are pursuing the Oracle PL/SQL Developer Accredited Associate certification, there are two tests that will satisfy the PL/SQL prerequisite: “1Z0-147: Plan with PL/SQL” and the more recent version: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a reasonable sum of confusion among the candidates trying to find certification about whether they really should consider one take a look at, or the other, or the two. The intent of this write-up is to assist clarify the two exams, their similarities and variations, and why you may well acquire a single over the other.

A single factor must be designed obvious from the outset: there is under no circumstances a reason to get both of those tests. In contrast to the DBA track, Oracle PL/SQL certifications are not tied to the databases release. You do not come to be licensed in release X of Oracle PL/SQL and then have a prerequisite to acquire up grade tests. For the reason that either of these two checks will satisfy the OCA-degree PL/SQL requirement, passing the other would provide no certification gain. That explained, you should choose which of the two tests to pursue. The 1Z0-147 exam is a number of decades older than 1Z0-144. Except there is a unique cause that using the more mature exam will gain you, your superior alternative is to go with the 11G version of the examination. Until finally Oracle retires 1Z0-147, nevertheless, the choice is yours.

The two exams have a excellent offer of commonality amongst them. This helps make feeling as they are for primarily the exact same matter. What is surprising is the number of variances that exist among the two. 1Z0-144 is not just a remake of the earlier test with new PL/SQL capabilities from variations 10G and 11G tacked on. There is an fully distinctive feel to the exam and the topics included. There are several sections that do not exist in 1Z0-147 which address functions that did not exist in 9i. Even so, the vast majority of the new sections in 1Z0-144 deal with core topics of PL/SQL programming that arguably ought to have been in the previously take a look at. Some of the varieties of facts protected in 1Z0-144 but not 1Z0-147 include things like:

  • The gains of working with PL/SQL
  • Programming fundamental principles, together with variables, conventions, characteristics, and lexical units
  • Use of SQL features in PL/SQL
  • Implicit vs. specific data conversion
  • Use of labels, indentation, and whitespace to make additional readable code
  • The use of DML in PL/SQL
  • The use of handle constructions and Loops
  • The use of cursors and cursor characteristics
  • The use of the FOR UPDATE clause
  • Exception Managing
  • PL/SQL Style considerations
  • Composite information kinds
  • Autonomous transactions
  • BULK SQL functions
  • PL/SQL compiler modifications

The number of subject areas lined in 1Z0-147 that are not lined in 1Z0-144 is a lot smaller. Nevertheless, the initially 3 are surprising thinking of the pronounced change to PL/SQL fundamentals in the 11G examination:

  • Privileges demanded to execute procedures
  • Parameter modes and DEFAULT values
  • Parameter passing approaches — by reference vs. by worth
  • A significantly larger sized emphasis on triggers
  • Far more references to customer-facet PL/SQL (1Z0-144 mostly ignores customer-facet)
  • Much more concentration on PL/SQL dependencies and invalidations
  • Significant objects and the use of the DBMS_LOB package

If you close up pursuing 1Z0-147, be confident to study utilizing the Oracle 9i documentation. Capabilities that had been included to PL/SQL in 10G or 11G will not be on that test. Acquiring investigated the matters for both of those tests, I contemplate 1Z0-144 to be the much better test from the standpoint of the facts examined. The subject matter is a improved combine of what is significant for an entry-stage PL/SQL developer to know. New developers finding out for this exam will occur out with a a lot more rounded and complete knowledge of PL/SQL fundamentals. Whichever exam you pursue, be positive to analyze just about every of the test subject areas listed on the Oracle Instruction site before scheduling the examination. Excellent luck on the take a look at.

Leave a Reply