Studying for 1Z0-047: Oracle Database SQL Expert
For Oracle specialists who are pursuing the Oracle PL/SQL Designer Qualified Associate qualification, there are 2 examinations that will certainly please the PL/SQL demand: “1Z0-147: Program with PL/SQL” as well as the newer version: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a fair quantity of complication amongst candidates seeking certification over whether they should take one examination, or the other, or both. The intent of this article is to help clarify both examinations, their similarities as well as distinctions, and why you could take one over the various other.
Something must be made clear from the start: there is never ever a factor to take both tests. Unlike the DBA track, Oracle PL/SQL accreditations are not tied to the data source release. You do not become accredited in release X of Oracle PL/SQL and after that have a need to take upgrade tests. Because either of these two examinations will please the OCA-level PL/SQL need, passing the various other would certainly provide no accreditation benefit. That stated, you should make a decision which of both tests to pursue. The 1Z0-147 examination is several years older than 1Z0-144. Unless there is a specific factor that taking the older test will benefit you, your much better option is to choose the 11G variation of the exam. Up until Oracle retires 1Z0-147, nevertheless, the selection is yours.
Both examinations have a lot of commonness in between them. This makes sense as they are for basically the same topic. What is surprising is the number of differences that exist in between both. 1Z0-144 is not merely a remake of the earlier test with new PL/SQL features from SQL London variations 10G as well as 11G tacked on. There is a completely various feel to the test and also the topics covered. There are numerous areas that do not exist in 1Z0-147 which cover features that did not exist in 9i. Nevertheless, the majority of the new sections in 1Z0-144 cover core topics of PL/SQL programming that probably need to have been in the earlier test. Several of the sorts of info covered in 1Z0-144 yet not 1Z0-147 consist of:
The advantages of utilizing PL/SQL
Setting fundamentals, consisting of variables, conventions, attributes, and lexical units
Use of SQL features in PL/SQL
Implied vs. specific data conversion
Use of labels, impression, as well as whitespace to make even more legible code
The use of DML in PL/SQL
Making use of control frameworks as well as Loops
The use of arrows and arrow features
Using the FOR UPDATE condition
PL/SQL Style factors to consider
Compound information kinds
BULK SQL operations
PL/SQL compiler changes
The number of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller. Nonetheless, the initial 3 are shocking considering the noticable shift to PL/SQL principles in the 11G examination:
Opportunities needed to implement procedures
Criterion modes and DEFAULT worths
Specification passing techniques– by referral vs. by value
A much larger focus on triggers
Much more referrals to client-side PL/SQL (1Z0-144 greatly disregards client-side).
A lot more concentrate on PL/SQL dependences and invalidations.
Large objects as well as using the DBMS_LOB package.
If you end up seeking 1Z0-147, make sure to study using the Oracle 9i documents. Abilities that were added to PL/SQL in 10G or 11G will certainly not get on that test. Having investigated the subjects for both tests, I think about 1Z0-144 to be the far better test from the standpoint of the info examined. The subject is a better mix of what is necessary for an entry-level PL/SQL programmer to know. New designers studying for this examination will come out with a much more spherical as well as complete understanding of PL/SQL principles. Whichever test you seek, make sure to research each of the examination topics noted on the Oracle Education and learning site before setting up the test. Good luck on the test.