Studying for 1Z0-051: Oracle Database 11g: SQL Fundamentals I

For Oracle experts who are pursuing the Oracle PL/SQL Programmer Certified Associate accreditation, there are 2 exams that will certainly satisfy the PL/SQL requirement: “1Z0-147: Program with PL/SQL” as well as the newer version: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a reasonable amount of complication among prospects seeking qualification over whether they must take one test, or the various other, or both. The intent of this write-up is to aid explain both tests, their similarities and differences, and also why you might take one over the other.

One thing must be explained from the beginning: there is never a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL certifications are not linked to the database release. You do not become accredited in launch X of Oracle PL/SQL and afterwards have a demand to take upgrade exams. Because either of these 2 examinations will please the OCA-level PL/SQL requirement, passing the other would certainly supply no qualification benefit. That stated, you should determine which of both examinations to seek. The 1Z0-147 examination is several years older than 1Z0-144. Unless there is a particular factor that taking the older examination will certainly benefit you, your better choice is to select the 11G variation of the exam. Till Oracle retires 1Z0-147, nonetheless, the choice is yours.

The two tests have a lot of commonness in between them. This makes sense as they are for essentially the exact same topic. What is unusual is the variety of distinctions that exist in between the two. 1Z0-144 is not just a remake of the earlier test with new PL/SQL features from variations 10G as well as 11G added. There is an entirely various feel to the examination and the subjects covered. There SQL Course are numerous areas that do not exist in 1Z0-147 which cover features that did not exist in 9i. However, most of the brand-new sections in 1Z0-144 cover core topics of PL/SQL programs that arguably need to have remained in the earlier test. Several of the types of information covered in 1Z0-144 yet not 1Z0-147 include:

The benefits of making use of PL/SQL
Configuring fundamentals, including variables, conventions, qualities, and also lexical devices
Use of SQL features in PL/SQL
Implied vs. explicit information conversion
Use tags, impression, and whitespace to make more understandable code
The use of DML in PL/SQL
The use of control frameworks and also Loops
The use of arrows as well as arrow features
Using the FOR UPDATE stipulation
Exemption Handling
PL/SQL Layout considerations
Composite information kinds
Independent transactions
BULK SQL procedures
PL/SQL compiler adjustments
The number of topics covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller. Nevertheless, the first three are unusual thinking about the pronounced change to PL/SQL basics in the 11G examination:

Opportunities required to execute procedures
Specification settings as well as DEFAULT worths
Parameter passing techniques– by referral vs. by value
A much bigger concentrate on triggers
A lot more referrals to client-side PL/SQL (1Z0-144 mainly neglects client-side).
Extra concentrate on PL/SQL reliances and also invalidations.
Big items and using the DBMS_LOB plan.
If you wind up going after 1Z0-147, make certain to research making use of the Oracle 9i paperwork. Capabilities that were added to PL/SQL in 10G or 11G will certainly not get on that examination. Having 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 evaluated. The subject is a far better mix of what is very important for an entry-level PL/SQL designer to recognize. New developers researching for this test will certainly bring out a much more rounded and complete understanding of PL/SQL fundamentals. Whichever test you go after, make sure to study each of the examination topics listed on the Oracle Education and learning site prior to arranging the examination. All the best on the examination.