For Oracle gurus who’re pursuing the Oracle PL/SQL Developer Licensed Affiliate certification, there are two exams that can fulfill the PL/SQL necessity: “1Z0-147: Plan with PL/SQL” and the newer model: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There’s a honest quantity of confusion amid candidates looking for certification in extra of no matter whether or not they need to purchase a single examination, or the opposite, or equally. The intent of this text is to help reveal the 2 exams, their similarities and variances, and why chances are you’ll presumably take a single concerning the different.

Only one matter have to be designed distinct from the outset: there’s hardly a rationale to think about each assessments. Not just like the DBA monitor, Oracle PL/SQL certifications aren’t tied to the database launch. You don’t turn into certified in launch X of Oracle PL/SQL after which have a requirement to take improve examinations. As a result of truth each of those two assessments will fulfill the OCA-level PL/SQL necessity, passing the opposite would provide no certification profit. That claimed, you’ll have to decide which of the 2 assessments to pursue. The 1Z0-147 take a look at is various years extra mature than 1Z0-144. Except after all there’s a particular clarification that taking the older examination will reward you, your higher risk is to go together with the 11G mannequin of the examination. Until Oracle retires 1Z0-147, having stated that, the selection is yours.

The 2 exams have a terrific deal of commonality between them. This helps make sense as they’re for mainly the identical matter. What’s shocking is the amount of variances that exist in between the 2. 1Z0-144 isn’t merely a remake of the earlier than check out with new PL/SQL attributes from variations 10G and 11G tacked on. There’s an absolutely totally different really feel to the examination and the topic areas coated. There are a variety of sections that don’t exist in 1Z0-147 which go over capabilities that didn’t exist in 9i. However, the the better a part of the brand new sections in 1Z0-144 tackle foremost subjects of PL/SQL programming that arguably actually ought to have been within the beforehand examination. Among the sorts of details coated in 1Z0-144 however not 1Z0-147 embody issues like:

• The rewards of constructing use of PL/SQL
• Programming fundamental rules, like variables, conventions, attributes, and lexical fashions
• Use of SQL capabilities in PL/SQL
• Implicit vs. particular data conversion
• Use of labels, indentation, and whitespace to make way more readable code
• Using DML in PL/SQL
• Using command constructions and Loops
• Using cursors and cursor traits
• Using the FOR UPDATE clause
• Exception Managing
• PL/SQL Format issues to think about
• Composite particulars varieties
• Autonomous transactions
• BULK SQL capabilities
• PL/SQL compiler variations

The collection of topics protected in 1Z0-147 that aren’t lined in 1Z0-144 is way scaled-down. Nonetheless, the first 3 are shocking considering the pronounced change to PL/SQL fundamentals within the 11G take a look at:

• Privileges wanted to execute procedures
• Parameter modes and DEFAULT values
• Parameter passing strategies — by reference vs. by profit
• A considerably a lot bigger focus on triggers
• Further references to shopper-aspect PL/SQL (1Z0-144 primarily ignores consumer-facet)
• Extra goal on PL/SQL dependencies and invalidations
• Vital objects and the usage of the DBMS_LOB bundle deal

If you happen to end up pursuing 1Z0-147, be assured to look at working with the Oracle 9i documentation. Talents that had been included to PL/SQL in 10G or 11G won’t be on that examination. Having researched the issues for every checks, I ponder 1Z0-144 to be the superior take a look at from the standpoint of the small print examined. The subject material topic is a superior combine of what’s very important for an entry-stage PL/SQL developer to know. New builders discovering out for this take a look at will happen out with a much more rounded and complete know-how of PL/SQL fundamentals. Whichever examination you pursue, be completely positive to analysis every particular person of the examination topics listed on the Oracle Coaching website previous to scheduling the examination. Good luck on the check out.