For Oracle gurus who are pursuing the Oracle PL/SQL Developer Certified Associate certification, there are two tests that will fulfill the PL/SQL need: “1Z0-147: Plan with PL/SQL” and the more recent edition: “1Z0-144: Oracle Databases 11g: System with PL/SQL”. There is a fair amount of confusion between candidates in search of certification in excess of irrespective of whether they should really consider 1 check, or the other, or each. The intent of this report is to assist make clear the two assessments, their similarities and variances, and why you may possibly consider 1 about the other.
A person issue must be produced clear from the outset: there is hardly ever a rationale to take both equally checks. Contrary to the DBA monitor, Oracle PL/SQL certifications are not tied to the database launch. You do not develop into licensed in release X of Oracle PL/SQL and then have a prerequisite to take up grade exams. Due to the fact either of these two tests will satisfy the OCA-level PL/SQL need, passing the other would present no certification reward. That claimed, you should come to a decision which of the two assessments to pursue. The 1Z0-147 examination is numerous years older than 1Z0-144. Until there is a particular rationale that getting the older examination will benefit you, your much better option is to go with the 11G edition of the exam. Right until Oracle retires 1Z0-147, having said that, the option is yours.
The two checks have a excellent offer of commonality among them. This would make sense as they are for fundamentally the very same subject matter. What is surprising is the variety of differences that exist amongst the two. 1Z0-144 is not just a remake of the previously take a look at with new PL/SQL attributes from variations 10G and 11G tacked on. There is an completely different sense to the exam and the subject areas included. There are a number of sections that do not exist in 1Z0-147 which protect capabilities that did not exist in 9i. Nevertheless, the the vast majority of the new sections in 1Z0-144 address main subjects of PL/SQL programming that arguably ought to have been in the before check. Some of the styles of facts lined in 1Z0-144 but not 1Z0-147 incorporate:
- The rewards of employing PL/SQL
- Programming basics, including variables, conventions, characteristics, and lexical models
- Use of SQL capabilities in PL/SQL
- Implicit vs. explicit info conversion
- Use of labels, indentation, and whitespace to make far more readable code
- The use of DML in PL/SQL
- The use of control constructions and Loops
- The use of cursors and cursor attributes
- The use of the FOR UPDATE clause
- Exception Handling
- PL/SQL Style and design issues
- Composite information forms
- Autonomous transactions
- BULK SQL functions
- PL/SQL compiler modifications
The number of topics included in 1Z0-147 that are not included in 1Z0-144 is a lot more compact. Having said that, the first 3 are astonishing looking at the pronounced shift to PL/SQL fundamentals in the 11G check:
- Privileges necessary to execute techniques
- Parameter modes and DEFAULT values
- Parameter passing solutions — by reference vs. by benefit
- A much much larger emphasis on triggers
- Much more references to shopper-side PL/SQL (1Z0-144 mainly ignores client-aspect)
- More emphasis on PL/SQL dependencies and invalidations
- Significant objects and the use of the DBMS_LOB deal
If you stop up pursuing 1Z0-147, be absolutely sure to review making use of the Oracle 9i documentation. Abilities that had been included to PL/SQL in 10G or 11G will not be on that take a look at. Getting investigated the matters for each exams, I take into account 1Z0-144 to be the improved exam from the standpoint of the details analyzed. The subject make any difference is a improved blend of what is vital for an entry-stage PL/SQL developer to know. New builders finding out for this exam will come out with a far more rounded and finish know-how of PL/SQL fundamentals. Whichever exam you go after, be certain to study every of the test subject areas shown on the Oracle Education and learning website prior to scheduling the exam. Fantastic luck on the take a look at.
