The initial of the Oracle 12c certification tests to go into creation is 1Z0-061: Oracle Database 12c: SQL Fundamentals. Oracle College put this exam into manufacturing nearly at the same time with the retirement of the a great deal older test 1Z0-007: Introduction to Oracle9i SQL. On the other hand, the 11g edition of the SQL Fundamentals exam, 1Z0-051, is still out there. Obtaining two equal tests in creation leads to a reasonable total of confusion amid certification candidates. In this article I will focus on the two examinations, what is different between them, and how to pick 1 more than the other.
Either will satisfy the SQL necessity for the “Oracle Database 11g Administrator Accredited Affiliate” or “Oracle PL/SQL Developer Licensed Affiliate” tracks. The SQL necessity can also be happy by passing 1Z0-047: Oracle Databases SQL Pro. Even so, 1Z0-047 is a significantly harder examination than both 1Z0-051 or 1Z0-061. This is an alternative that need to only be regarded as if you have worked with Oracle SQL thoroughly. This article focuses on the SQL fundamentals examinations.
The 11g and 12c SQL Fundamentals tests are almost equivalent in phrases of content lined and demands pleased for Oracle certifications. Oracle does not involve you to use the 12c SQL Fundamentals when pursuing the 12c DBA observe or the 11g exam for the DBA observe in that release. Any Oracle SQL exam (which includes retired ones) can be utilized for any Oracle certification track that has a SQL need. For example, the SQL test I took more than a 10 years in the past was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That test has been retired for several years, but could however be used for the 12c observe.
When the articles of the two examinations is really similar, there are a couple of distinctions. Equally 1Z0-051 and 1Z0-061 include forty-1 topics. Of these, thirty-6 are typical to both of those exams. This signifies the tests have about 88% commonality by matter count. The previous segment of the 11g examination (Creating Other Schema Objects) was taken off from the test in the 12c variation. The subject areas lined in that area are:
- Develop easy and complex sights
- Retrieve knowledge from sights
- Create, keep, and use sequences
- Make and maintain indexes
- Generate private and public synonyms
For the 1Z0-061 test, Oracle University additional a new ‘Introduction’ part with the following 4 matters:
- Explain the attributes of Oracle Databases 12c
- Describe the salient attributes of Oracle Cloud 12c
- Make clear the theoretical and bodily facets of a relational databases
- Explain Oracle server’s implementation of RDBMS and object relational databases administration method (ORDBMS)
They also additional 1 a lot more subject to the “Controlling Tables employing DML statements” section:
- Truncate data
I have to say that I am incredibly unhappy with Oracle University’s determination to place TRUNCATE (which is a DDL procedure) below a part specially about DML statements. This is not anything that would make sense in a exam developed for people who are new to SQL. I am positive that OU would be heartbroken to learn of my disapproval.
The 1Z0-061 test has 9 much more issues than 1Z0-051 (75 vs 66) and a a little bit higher passing score (65% vs 60%). This does not necessarily mean that the check is tougher to pass, while. The subject areas that have been included are ones that are likely to have thoughts that are a lot more uncomplicated than the subjects that have been eliminated. OU has a specified goal proportion of candidates that they want to move each individual take a look at on a to start with attempt. If they raised the passing rating, it was due to the fact they felt the current take a look at experienced less difficult questions.
I have to say that deciding on one exam more than the other is genuinely a toss-up. The 11g exam is not significantly dated and all of the topics are nevertheless applicable. There may possibly be a very little little bit of very long-expression gain in owning the 12c test on your document fairly than 11g, simply mainly because 12c will be about soon after 11g is retired. Nevertheless, 11g is now the common databases employed in output environments. Incredibly few organizations will have moved to 12c nevertheless. In addition, none of my businesses have inquired (or cared) about the particular checks I took to get my Oracle certifications. Decide the exam that helps make the most feeling to you and you can be assured that you are not generating a slip-up. Whichever 1 you choose, great luck on the examination.