The first of the Oracle 12c recognition exams to go into production is 70-533: Oracle Database 12c: SQL Fundamentals. Oracle University or college put this exam into production almost simultaneously with the retirement of the much older exam 70-533: Introduction to Oracle9i SQL. However, the 11g version of the SQL Principles exam, 1Z0-051, remains to be available. Having two equivalent examinations in production brings about a fair amount of distress among documentation candidates. In this post I will discuss the two exams, what is different between them, as well as how to choose one over the other. 70-533 dumps
Either will gratify the SQL requirement for the “Oracle Database 11g Administrator Certified Associate” or “Oracle PL/SQL Developer Accredited Associate” tracks. The SQL requirement can even be satisfied by passing 1Z0-047: Oracle Data source SQL Expert. Yet , 70-533 is a considerably harder exam than either 1Z0-051 or 1Z0-061. This is certainly an option that should only be considered if you have worked with Oracle SQL extensively. This information centers on the SQL principles exams.
The 11g and 12c SQL Fundamentals tests are almost identical in conditions of content protected and requirements satisfied for Oracle certifications. Oracle will not require you to use the 12c SQL Principles when following a 12c DBA track or maybe the 11g exam for the DBA track in that release. Any Oracle SQL exam (including retired ones) can be used for any Oracle recognition track that has a SQL necessity. For example, the SQL test I took over a decade ago was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That test has been the particular for a long time, but could still be sent applications for the 12c track.
As the content of the two exams is very similar, there are a few differences. Equally 70-533 contain forty-one topics. Of the people, thirty-six are common to both exams. This means the tests have about 88% commonality by topic count number. The final section of the 11g exam (Creating Additional Schema Objects) was removed from the exam in the 12c version. The subject areas covered in that section are:
Create simple and complex views
Obtain data from views
Generate, maintain, and use sequences
Create and look after indexes
Generate private and public word and phrase replacements
For the 1Z0-061 exam, Oracle University added a new ‘Introduction’ section with the following four subject areas:
Describe the features of Oracle Database 12c
Identify the salient features of Oracle Cloud 12c
Describe the theoretical and physical aspects of a relational database
Describe Oracle server’s implementation of RDBMS and object relational database software system (ORDBMS)
They also added one more topic to the “Managing Tables using DML statements” section:
I have to say that I i am very disappointed with Oracle University’s decision to put TRUNCATE (which is a DDL operation) under a section specifically about DML statements. This may not be something that makes sense in a test made for people who find themselves new to SQL. I was sure that OU would be heartbroken to learn of my disapproval.
The 1Z0-061 exam has seven more questions than 1Z0-051 (75 vs 66) and a slightly higher completing score (65% vs 60%). This does not automatically mean that quality is harder to pass, though. The issues that contain been added are ones that are likely to have questions that are more simple than the issues that had been removed. OU has a certain target percentage of individuals that they want to pass each test on a first strive. If they raised the passing score, it was because they felt the updated test had easier questions.
I have to admit choosing one test above the other is absolutely a toss-up. The 11g exam is not particularly went out with and all sorts of the issues are still relevant. There might be a little bit of long term benefit in having the 12c exam on your record rather than 11g, simply because 12c will be around after 11g is retired. However, 11g is currently the standard database utilized in production conditions. Very few companies will have moved to 12c yet. In addition, none of them of my employers have inquired (or cared) about the particular tests I got to gain my Oracle certifications. Choose the exam that makes the most sense to you and you will be confident that you are not making a fault. Whichever one you decide on, good luck on the test.