For Oracle professionals who are pursuing the Oracle PL/SQL Developer Certified Associate documentation, there are two tests that will meet the PL/SQL requirement: “70-534 : Program with PL/SQL” and the newer version: “70-534 : Oracle Database 11g: Program with PL/SQL”. There is a fair amount of dilemma among prospects seeking recognition over whether they is going to take one test, or the other, or both. The intent of this article is to help clarify the two tests, their similarities and differences, and why you may take one over the other. 70-534 dumps

One thing should be made clear from the start: there is never reasons to take both assessments. Unlike the DBA monitor, Oracle PL/SQL certifications are not tied to the database release. You never become qualified in release X of Oracle PL/SQL and then have a requirement to take upgrade exams. Because either of these two tests will meet the OCA-level PL/SQL requirement, passing the other would provide no certification benefit. That said, you must make a decision which of the 2 assessments to pursue. The 70-534  test is a long period older than 70-534 . Unless there is a specific reason that taking the older test will advantage you, your better option is to go with the 11G version of the exam. Until Oracle retires 70-534 , however , the choice is yours.

The two tests have a great deal of commonality together. This makes sense as they are for essentially the same topic. What is surprising is the number of variations that exist between the two. 70-534  is not simply a remake of the earlier test with new PL/SQL features from types 10G and 11G tacked on. There is an entirely different feel to the test and the subject areas covered. There are several sections which experts claim not exist in 70-534 which cover features that did not exist in 9i. However, the majority of the new sections in 70-534  cover core matters of PL/SQL programming that arguably should have experienced the earlier test. Some of the types of information covered in 70-534  but not 70-534  include:

The benefits of using PL/SQL
Programming basics, including parameters, conventions, attributes, and lexical models
Use of SQL functions in PL/SQL
Acted vs. explicit data alteration
Use of labels, indentation, and whitespace to make more readable code
The use of DML in PL/SQL
The use of control structures and Loops
The use of cursors and cursor attributes
The use of the FOR UPDATE clause
Exception Managing
PL/SQL Design considerations
Amalgamated data types
Autonomous deals
BULK SQL operations
PL/SQL compiler changes
The amount of matters covered in 70-534  that are not covered in 70-534  is a lot smaller. Nevertheless, the first three are surprising taking into consideration the pronounced move to PL/SQL fundamentals in the 11G test:

Privileges required to execute methods
Parameter modes and STANDARD values
Parameter passing methods — by reference versus. by value
A much larger sized give attention to triggers
More referrals to client-side PL/SQL (70-534  largely ignores client-side)
More give attention to PL/SQL dependencies and invalidations
Large objects and the use of the DBMS_LOB bundle
If you wrap up pursuing 70-534 , be sure to study using the Oracle 9i documentation. Functions that were added to PL/SQL in 10G or 11G are not on that test. Having researched the issues for both assessments, I consider 70-534  to be the better exam from the standpoint of the information tested. The subject matter is an improved mix of precisely what is important for an entry-level PL/SQL developer to know. Fresh developers studying for this exam can come out with a more rounded and complete knowledge of PL/SQL fundamentals. Whichever exam you pursue, make certain to examine each of the exam matters listed on the Oracle Education site before scheduling the exam. Good good fortune on the test.

Leave a Reply

Your email address will not be published. Required fields are marked *