Oracle SQL Certification: 1Z0-051 or 1Z0-061?

By Donna Thompson 5 months ago

The to start with of the Oracle 12c certification exams to go into manufacturing is 1Z0-061: Oracle Database 12c: SQL Fundamentals. Oracle University place this examination into output practically simultaneously with the retirement of the a great deal older test 1Z0-007: Introduction to Oracle9i SQL. Even so, the 11g variation of the SQL Fundamentals exam, 1Z0-051, is even now obtainable. Having two equal examinations in output leads to a reasonable amount of confusion amid certification candidates. In this short article I will go over the two examinations, what is distinctive in between them, and how to select just one more than the other.

Possibly will fulfill the SQL necessity for the “Oracle Database 11g Administrator Qualified Associate” or “Oracle PL/SQL Developer Licensed Affiliate” tracks. The SQL prerequisite can also be content by passing 1Z0-047: Oracle Databases SQL Specialist. On the other hand, 1Z0-047 is a considerably harder test than both 1Z0-051 or 1Z0-061. This is an option that need to only be deemed if you have worked with Oracle SQL thoroughly. This posting focuses on the SQL fundamentals examinations.

The 11g and 12c SQL Fundamentals tests are virtually similar in phrases of written content included and prerequisites content for Oracle certifications. Oracle does not have to have you to use the 12c SQL Fundamentals when pursuing the 12c DBA track or the 11g test for the DBA track in that release. Any Oracle SQL examination (which include retired ones) can be utilized for any Oracle certification keep track of that has a SQL necessity. For example, the SQL exam I took more than a ten years back was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That test has been retired for decades, but could continue to be used for the 12c observe.

Although the articles of the two tests is quite related, there are a handful of discrepancies. Equally 1Z0-051 and 1Z0-061 comprise forty-1 matters. Of these, 30-6 are typical to both of those examinations. This signifies the assessments have about 88% commonality by matter count. The very last area of the 11g test (Making Other Schema Objects) was taken out from the test in the 12c edition. The subjects included in that portion are:

  • Generate very simple and complicated views
  • Retrieve facts from sights
  • Generate, keep, and use sequences
  • Create and retain indexes
  • Make non-public and public synonyms

For the 1Z0-061 test, Oracle College added a new ‘Introduction’ area with the next four subjects:

  • Describe the characteristics of Oracle Databases 12c
  • Explain the salient features of Oracle Cloud 12c
  • Describe the theoretical and bodily aspects of a relational database
  • Describe Oracle server’s implementation of RDBMS and object relational database administration technique (ORDBMS)

They also added one particular far more subject to the “Managing Tables making use of DML statements” segment:

  • Truncate data

I have to say that I am incredibly upset with Oracle University’s choice to place TRUNCATE (which is a DDL procedure) underneath a segment specially about DML statements. This is not a thing that would make sense in a exam intended for folks who are new to SQL. I am guaranteed that OU would be heartbroken to master of my disapproval.

The 1Z0-061 examination has nine much more thoughts than 1Z0-051 (75 vs 66) and a slightly greater passing score (65% vs 60%). This does not always suggest that the check is more challenging to pass, although. The subjects that have been additional are ones that are most likely to have inquiries that are additional uncomplicated than the matters that were being taken off. OU has a selected target proportion of candidates that they want to go every test on a first attempt. If they elevated the passing rating, it was simply because they felt the updated test experienced easier inquiries.

I have to say that picking just one take a look at more than the other is really a toss-up. The 11g exam is not specifically dated and all of the topics are still relevant. There may possibly be a little little bit of lengthy-term benefit in obtaining the 12c examination on your record relatively than 11g, basically because 12c will be around following 11g is retired. Nonetheless, 11g is currently the common database made use of in creation environments. Very several firms will have moved to 12c but. In addition, none of my companies have inquired (or cared) about the distinct tests I took to obtain my Oracle certifications. Decide on the examination that would make the most sense to you and you can be assured that you are not earning a miscalculation. Whichever just one you pick, fantastic luck on the take a look at.

Leave a Reply