Study Guide for 1Z0-061: Oracle Database 12c: SQL Fundamentals

For Oracle specialists who are going after the Oracle PL/SQL Programmer Qualified Associate accreditation, there are 2 tests that will please the PL/SQL requirement: “1Z0-147: Program with PL/SQL” and the newer version: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a reasonable quantity of confusion amongst candidates looking for qualification over whether they must take one test, or the various other, or both. The intent of this short article is to assist describe the two examinations, their similarities and also differences, and why you may take one over the other.

Something must be made clear from the start: there is never ever a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL qualifications are not tied to the database release. You do not become accredited in release X of Oracle PL/SQL and then have a need to take upgrade tests. Because either of these two tests will certainly satisfy the OCA-level PL/SQL need, passing the other would provide no qualification benefit. That claimed, you need to make a decision which of the two examinations to go after. The 1Z0-147 examination is several years older than 1Z0-144. Unless there is a particular factor that taking the older test will certainly benefit you, your far better alternative is to opt for the 11G version of the examination. Up until Oracle retires 1Z0-147, nevertheless, the option is yours.

The two examinations have a great deal of commonality between them. This makes good sense as they are for essentially the very same topic. What is unexpected is the variety of distinctions that exist between the two. 1Z0-144 is not just a remake of the earlier test with new PL/SQL attributes from variations 10G and 11G added. There SQL Course is a completely various feeling to the test as well as the subjects covered. There are several sections that do not exist in 1Z0-147 which cover attributes that did not exist in 9i. However, most of the new areas in 1Z0-144 cover core topics of PL/SQL programs that perhaps ought to have remained in the earlier test. Several of the types of info covered in 1Z0-144 but not 1Z0-147 consist of:

The benefits of using PL/SQL
Programming essentials, consisting of variables, conventions, attributes, as well as lexical systems
Use of SQL features in PL/SQL
Implied vs. explicit data conversion
Use tags, indentation, and also whitespace to make even more readable code
Using DML in PL/SQL
Making use of control frameworks and Loops
Using cursors as well as cursor characteristics
Making use of the FOR UPDATE provision
Exception Handling
PL/SQL Layout considerations
Compound information kinds
Self-governing transactions
BULK SQL procedures
PL/SQL compiler changes
The number of topics covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller sized. Nonetheless, the very first 3 are unusual taking into consideration the pronounced shift to PL/SQL principles in the 11G examination:

Benefits called for to implement treatments
Criterion settings as well as DEFAULT worths
Specification passing approaches– by referral vs. by value
A much bigger concentrate on triggers
Extra recommendations to client-side PL/SQL (1Z0-144 greatly disregards client-side).
A lot more focus on PL/SQL dependences and invalidations.
Large objects as well as making use of the DBMS_LOB bundle.
If you wind up pursuing 1Z0-147, make sure to examine using the Oracle 9i documentation. Abilities that were contributed to PL/SQL in 10G or 11G will certainly not be on that examination. Having actually investigated the topics for both tests, I take into consideration 1Z0-144 to be the far better exam from the point ofview of the details examined. The subject matter is a better mix of what is important for an entry-level PL/SQL programmer to recognize. New programmers studying for this exam will certainly come out with a more spherical as well as complete understanding of PL/SQL fundamentals. Whichever examination you pursue, be sure to study each of the examination subjects noted on the Oracle Education and learning site before arranging the exam. Good luck on the examination.