The first of the Oracle 12c certification exams to go into creation is 1Z0-061: Oracle Database 12c: SQL Fundamentals. Oracle College set this test into generation virtually simultaneously with the retirement of the substantially more mature examination 1Z0-007: Introduction to Oracle9i SQL. Nevertheless, the 11g variation of the SQL Fundamentals examination, 1Z0-051, is even now available. Having two equal tests in output prospects to a honest volume of confusion between certification candidates. In this posting I will explore the two examinations, what is distinct in between them, and how to select 1 over the other.
Either will satisfy the SQL requirement for the “Oracle Database 11g Administrator Accredited Affiliate” or “Oracle PL/SQL Developer Qualified Associate” tracks. The SQL necessity can also be glad by passing 1Z0-047: Oracle Database SQL Qualified. Nevertheless, 1Z0-047 is a substantially more challenging examination than possibly 1Z0-051 or 1Z0-061. This is an alternative that really should only be viewed as if you have labored with Oracle SQL extensively. This write-up focuses on the SQL fundamentals examinations.
The 11g and 12c SQL Fundamentals tests are almost similar in conditions of content material protected and necessities glad for Oracle certifications. Oracle does not require you to use the 12c SQL Fundamentals when pursuing the 12c DBA observe or the 11g exam for the DBA track in that release. Any Oracle SQL exam (including retired kinds) can be employed for any Oracle certification monitor that has a SQL requirement. For case in point, the SQL test I took about a 10 years in the past was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That take a look at has been retired for decades, but could still be applied for the 12c keep track of.
Though the content material of the two tests is extremely related, there are a number of variations. The two 1Z0-051 and 1Z0-061 have forty-a single topics. Of people, 30-six are common to both tests. This indicates the exams have about 88% commonality by topic depend. The very last portion of the 11g exam (Generating Other Schema Objects) was taken off from the examination in the 12c edition. The topics protected in that area are:
- Develop simple and intricate views
- Retrieve info from sights
- Generate, sustain, and use sequences
- Generate and sustain indexes
- Build private and general public synonyms
For the 1Z0-061 exam, Oracle University added a new ‘Introduction’ portion with the adhering to four matters:
- Describe the characteristics of Oracle Database 12c
- Describe the salient features of Oracle Cloud 12c
- Explain the theoretical and actual physical aspects of a relational database
- Describe Oracle server’s implementation of RDBMS and object relational database administration program (ORDBMS)
They also added one a lot more subject to the “Controlling Tables applying DML statements” portion:
- Truncate details
I have to say that I am pretty dissatisfied with Oracle University’s selection to put TRUNCATE (which is a DDL operation) beneath a part exclusively about DML statements. This is not some thing that tends to make perception in a check built for folks who are new to SQL. I am sure that OU would be heartbroken to find out of my disapproval.
The 1Z0-061 examination has 9 much more queries than 1Z0-051 (75 vs 66) and a a little bit larger passing rating (65% vs 60%). This does not necessarily suggest that the examination is more difficult to go, though. The subject areas that have been included are types that are probably to have inquiries that are far more clear-cut than the matters that have been eradicated. OU has a specific focus on percentage of candidates that they want to move every single examination on a 1st try. If they elevated the passing rating, it was since they felt the up-to-date examination experienced less complicated concerns.
I have to say that deciding upon 1 check about the other is definitely a toss-up. The 11g exam is not notably dated and all of the subjects are however appropriate. There could possibly be a minor little bit of very long-expression reward in owning the 12c examination on your record alternatively than 11g, simply just simply because 12c will be all-around immediately after 11g is retired. Having said that, 11g is at this time the standard database used in creation environments. Quite few organizations will have moved to 12c however. In addition, none of my businesses have inquired (or cared) about the distinct assessments I took to acquire my Oracle certifications. Decide on the test that makes the most feeling to you and you can be self-confident that you are not making a slip-up. Whichever a person you decide on, good luck on the check.