Oracle SQL Certification: 1Z0-051 or 1Z0-061?
- June 15, 2017
- Posted by: marlenedubois
- Category: Home Health Aide Training
The first of the Oracle 12c certification exams to go into production will be 1Z0-061: Oracle Database 12c: SQL Fundamentals. Oracle University put This kind of exam into production almost simultaneously with the retirement of the much older exam 1Z0-007: Introduction to Oracle9i SQL. However, the 11g style of the SQL Fundamentals exam, 1Z0-051, will be still available. Having two equivalent exams in production leads to a fair amount of confusion among certification candidates. In This kind of article I will discuss the two exams, what will be different between them, and also also also how to choose one over the additional.
Either will satisfy the SQL requirement for the “Oracle Database 11g Administrator Certified Associate” or “Oracle PL/SQL Developer Certified Associate” tracks. The SQL requirement can also be satisfied by passing 1Z0-047: Oracle Database SQL Expert. However, 1Z0-047 will be a considerably harder exam than either 1Z0-051 or 1Z0-061. This kind of will be an option which should only be considered if you have worked with Oracle SQL extensively. This kind of article focuses on the SQL fundamentals exams.
The 11g and also also also 12c SQL Fundamentals exams are almost identical in terms of content covered and also also also requirements satisfied for Oracle certifications. Oracle does not require you to use the 12c SQL Fundamentals when pursuing the 12c DBA track or the 11g exam for the DBA track in which Discharge. Any Oracle SQL exam (including retired ones) can be used for any Oracle certification track which carries a SQL requirement. For example, the SQL test I took over a decade ago was 1Z0-001: Introduction to Oracle: SQL and also also also PL/SQL. which test has been retired for years, although could still be applied for the 12c track.
While the content of the two exams will be very similar, there are a few differences. Both 1Z0-051 and also also also 1Z0-061 contain forty-one topics. Of those, thirty-six are common to both exams. This kind of means the tests have about 88% commonality by topic count. The last section of the 11g exam (Creating additional Schema Objects) was removed through the exam within the 12c style. The topics covered in which section are:
- Create simple and also also also complex views
- Retrieve data through views
- Create, maintain, and also also also use sequences
- Create and also also also maintain indexes
- Create private and also also also public synonyms
For the 1Z0-061 exam, Oracle University added a brand-new ‘Introduction’ section with the following four topics:
- Describe the features of Oracle Database 12c
- Describe the salient features of Oracle Cloud 12c
- Explain the theoretical and also also also physical aspects of a relational database
- Describe Oracle server’s implementation of RDBMS and also also also object relational database management system (ORDBMS)
They also added one more topic to the “Managing Tables using DML statements” section:
- Truncate data
I have to say which I am very disappointed with Oracle University’s decision to put TRUNCATE (which will be a DDL operation) under a section specifically about DML statements. This kind of will be not something which makes sense in a test designed for people who are brand-new to SQL. I am sure which OU might be heartbroken to learn of my disapproval.
The 1Z0-061 exam has nine more questions than 1Z0-051 (75 vs 66) and also also also a slightly higher passing score (65% vs 60%). This kind of does not necessarily mean which the test will be harder to pass, though. The topics which have been added are ones which are likely to have questions which are more straightforward than the topics which were removed. OU carries a certain target percentage of candidates which they want to pass each test on a first attempt. If they raised the passing score, the item was because they felt the updated test had easier questions.
I have to say which choosing one test over the additional will be genuinely a toss-up. The 11g exam will be not particularly dated and also also also all of the topics 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 will be retired. However, 11g will be currently the standard database used in production environments. Very few companies will have moved to 12c yet. In addition, none of my employers have inquired (or cared) about the specific tests I took to gain my Oracle certifications. Pick the exam which makes the most sense to you and also also also you can be confident which you are not generating a mistake. Whichever one you choose, not bad luck on the test.