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

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

By Mary J. Nolasco 2 years ago

For Oracle experts who are pursuing the Oracle PL/SQL Developer Qualified Affiliate certification, there are two examinations that will satisfy the PL/SQL need: “1Z0-147: Program with PL/SQL” and the newer edition: “1Z0-144: Oracle Databases 11g: Plan with PL/SQL”. There is a good sum of confusion between candidates searching for certification more than whether or not they must take one check, or the other, or the two. The intent of this article is to support clarify the two checks, their similarities and dissimilarities, and why you may well take 1 around the other.

Just one factor should be designed obvious from the outset: there is in no way a purpose to just take both of those tests. Compared with the DBA track, Oracle PL/SQL certifications are not tied to the databases launch. You do not grow to be licensed in launch X of Oracle PL/SQL and then have a prerequisite to just take enhance examinations. For the reason that possibly of these two checks will satisfy the OCA-stage PL/SQL necessity, passing the other would offer no certification gain. That said, you need to decide which of the two exams to go after. The 1Z0-147 exam is quite a few decades more mature than 1Z0-144. Except there is a unique motive that having the older test will gain you, your much better possibility is to go with the 11G edition of the examination. Until Oracle retires 1Z0-147, nonetheless, the choice is yours.

The two tests have a wonderful offer of commonality amongst them. This would make sense as they are for in essence the same subject. What is astonishing is the amount of dissimilarities that exist between the two. 1Z0-144 is not simply just a remake of the before test with new PL/SQL characteristics from variations 10G and 11G tacked on. There is an completely diverse sense to the check and the subjects lined. There are many sections that do not exist in 1Z0-147 which deal with options that did not exist in 9i. Even so, the the vast majority of the new sections in 1Z0-144 cover main subject areas of PL/SQL programming that arguably need to have been in the before exam. Some of the styles of information included in 1Z0-144 but not 1Z0-147 include:

  • The rewards of applying PL/SQL
  • Programming basic principles, together with variables, conventions, attributes, and lexical models
  • Use of SQL features in PL/SQL
  • Implicit vs. explicit data conversion
  • Use of labels, indentation, and whitespace to make more readable code
  • The use of DML in PL/SQL
  • The use of command constructions and Loops
  • The use of cursors and cursor attributes
  • The use of the FOR UPDATE clause
  • Exception Managing
  • PL/SQL Design criteria
  • Composite details kinds
  • Autonomous transactions
  • BULK SQL operations
  • PL/SQL compiler alterations

The variety of matters covered in 1Z0-147 that are not lined in 1Z0-144 is a great deal smaller sized. On the other hand, the 1st a few are surprising taking into consideration the pronounced change to PL/SQL fundamentals in the 11G check:

  • Privileges required to execute processes
  • Parameter modes and DEFAULT values
  • Parameter passing approaches — by reference vs. by worth
  • A much more substantial target on triggers
  • Much more references to client-facet PL/SQL (1Z0-144 mainly ignores shopper-facet)
  • Much more target on PL/SQL dependencies and invalidations
  • Significant objects and the use of the DBMS_LOB package

If you stop up pursuing 1Z0-147, be certain to research making use of the Oracle 9i documentation. Capabilities that ended up included to PL/SQL in 10G or 11G will not be on that check. Obtaining researched the matters for the two assessments, I take into consideration 1Z0-144 to be the much better examination from the standpoint of the data examined. The issue subject is a greater blend of what is important for an entry-degree PL/SQL developer to know. New developers researching for this exam will come out with a much more rounded and comprehensive know-how of PL/SQL fundamentals. Whichever examination you go after, be positive to research just about every of the examination subject areas detailed on the Oracle Education and learning web site just before scheduling the exam. Very good luck on the check.