Menu Close

Studying for 1Z0-146: Oracle Database 11g: Advanced PL/SQL

For Oracle experts who are seeking the Oracle PL/SQL Developer Qualified Associate accreditation, there are 2 tests that will certainly satisfy the PL/SQL need: “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 amount of confusion among candidates looking for certification over whether they ought to take one test, or the various other, or both. The intent of this post is to assist discuss both tests, their similarities and also differences, and why you may take one over the various other.

Something ought to be made clear from the start: there is never ever a factor to take both tests. Unlike the DBA track, Oracle PL/SQL certifications are not connected to the data source launch. You do not become licensed in release X of Oracle PL/SQL and afterwards have a demand SQL London to take upgrade exams. Because either of these two tests will satisfy the OCA-level PL/SQL need, passing the various other would supply no qualification benefit. That claimed, you should decide which of the two tests to seek. The 1Z0-147 test is numerous years older than 1Z0-144. Unless there is a particular reason that taking the older test will certainly benefit you, your better option is to opt for the 11G version of the examination. Until Oracle retires 1Z0-147, however, the option is yours.

Both examinations have a good deal of commonness between them. This makes sense as they are for essentially the very same topic. What is unexpected is the variety of differences that exist between the two. 1Z0-144 is not simply a remake of the earlier test with brand-new PL/SQL features from versions 10G and 11G tacked on. There is a totally various feeling to the examination as well as the topics covered. There are a number of sections that do not exist in 1Z0-147 which cover functions that did not exist in 9i. Nonetheless, most of the new sections in 1Z0-144 cover core subjects of PL/SQL shows that arguably should have remained in the earlier test. A few of the types of details covered in 1Z0-144 yet not 1Z0-147 include:

The advantages of using PL/SQL
Configuring fundamentals, including variables, conventions, features, and also lexical devices
Use SQL features in PL/SQL
Implied vs. specific information conversion
Use labels, indentation, and also whitespace to make more readable code
Making use of DML in PL/SQL
The use of control frameworks as well as Loopholes
Making use of cursors and arrow attributes
The use of the FOR UPDATE clause
Exemption Handling
PL/SQL Style considerations
Compound information kinds
Autonomous deals
BULK SQL procedures
PL/SQL compiler changes
The number of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller sized. Nonetheless, the initial three are surprising taking into consideration the obvious shift to PL/SQL basics in the 11G examination:

Privileges called for to perform procedures
Specification modes and also DEFAULT worths
Criterion passing approaches– by recommendation vs. by worth
A much larger focus on triggers
More references to client-side PL/SQL (1Z0-144 mainly ignores client-side).
More concentrate on PL/SQL dependencies and invalidations.
Huge objects as well as making use of the DBMS_LOB plan.
If you wind up going after 1Z0-147, be sure to study making use of the Oracle 9i documents. Capabilities that were contributed to PL/SQL in 10G or 11G will not get on that examination. Having researched the subjects for both examinations, I take into consideration 1Z0-144 to be the much better examination from the perspective of the info evaluated. The topic is a much better mix of what is necessary for an entry-level PL/SQL designer to understand. New developers examining for this examination will certainly come out with a much more rounded and total understanding of PL/SQL basics. Whichever examination you seek, make certain to research each of the examination topics provided on the Oracle Education and learning website prior to arranging the test. All the best on the test.