For Oracle experts that are going after the Oracle PL/SQL Developer Certified Associate certification, there are two examinations that will certainly satisfy the PL/SQL demand: “1Z0-147: Program with PL/SQL” as well as the more recent version: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a fair quantity of complication among candidates seeking accreditation over whether they need to take one test, or the other, or both. The intent of this write-up is to help discuss both examinations, their similarities and differences, as well as why you might take one over the various other.
One point ought to be explained from the start: there is never a reason to take both tests. Unlike the DBA track, Oracle PL/SQL certifications are not tied to the data source launch. You do not become licensed in release X of Oracle PL/SQL and afterwards have a requirement to take upgrade exams. Due to the fact that either of these two tests will certainly please the OCA-level PL/SQL requirement, passing the other would provide no accreditation advantage. That claimed, you have to decide which of the two tests to go after. The 1Z0-147 examination is several years older than 1Z0-144. Unless there is a particular factor that taking the older examination will profit you, your far better alternative is to choose the 11G variation of the exam. Till Oracle retires 1Z0-147, nonetheless, the choice is your own.
The two examinations have a large amount of commonness between them. This makes sense as they are for basically the very same topic. What is unusual is the variety of differences that exist in between both. 1Z0-144 is not merely a remake of the earlier examination with SQL London brand-new PL/SQL functions from variations 10G and 11G added. There is a completely different feeling to the test and the topics covered. There are several sections that do not exist in 1Z0-147 which cover features that did not exist in 9i. Nevertheless, the majority of the new areas in 1Z0-144 cover core subjects of PL/SQL programming that probably need to have been in the earlier test. A few of the kinds of info covered in 1Z0-144 however not 1Z0-147 consist of:
The benefits of using PL/SQL
Programming fundamentals, including variables, conventions, attributes, and also lexical devices
Use of SQL functions in PL/SQL
Implicit vs. specific information conversion
Use of tags, imprint, as well as whitespace to make even more legible code
The use of DML in PL/SQL
Using control frameworks and also Loops
Using cursors as well as arrow qualities
Using the FOR UPDATE condition
PL/SQL Style factors to consider
Compound data kinds
MASS SQL operations
PL/SQL compiler modifications
The variety of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller sized. However, the very first 3 are unusual taking into consideration the obvious change to PL/SQL fundamentals in the 11G examination:
Opportunities called for to execute procedures
Parameter modes as well as DEFAULT values
Parameter passing techniques– by referral vs. by worth
A much larger concentrate on triggers
Extra referrals to client-side PL/SQL (1Z0-144 greatly overlooks client-side).
Much more focus on PL/SQL dependencies and invalidations.
Huge items and also the use of the DBMS_LOB plan.
If you end up pursuing 1Z0-147, be sure to research using the Oracle 9i documents. Abilities that were contributed to PL/SQL in 10G or 11G will not get on that test. Having looked into the topics for both examinations, I think about 1Z0-144 to be the far better exam from the perspective of the details tested. The topic is a much better mix of what is essential for an entry-level PL/SQL programmer to recognize. New programmers examining for this examination will certainly come out with an extra spherical and also total knowledge of PL/SQL principles. Whichever test you seek, be sure to study each of the test subjects detailed on the Oracle Education site before arranging the examination. Good luck on the test.