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

The 1st of the Oracle 12c certification exams to go into generation is 1Z0-061: Oracle Databases 12c: SQL Fundamentals. Oracle University put this examination into manufacturing pretty much at the same time with the retirement of the a lot older examination 1Z0-007: Introduction to Oracle9i SQL. Having said that, the 11g model of the SQL Fundamentals exam, 1Z0-051, is continue to accessible. Having two equal exams in output potential customers to a fair total of confusion amongst certification candidates. In this write-up I will explore the two examinations, what is unique in between them, and how to pick a person in excess of the other.

Either will fulfill the SQL necessity for the “Oracle Database 11g Administrator Certified Affiliate” or “Oracle PL/SQL Developer Licensed Associate” tracks. The SQL need can also be pleased by passing 1Z0-047: Oracle Database SQL Qualified. However, 1Z0-047 is a substantially more durable test than possibly 1Z0-051 or 1Z0-061. This is an alternative that should only be deemed if you have worked with Oracle SQL thoroughly. This report focuses on the SQL fundamentals tests.

The 11g and 12c SQL Fundamentals tests are pretty much similar in conditions of written content lined and demands pleased 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 keep track of in that launch. Any Oracle SQL exam (including retired types) can be applied for any Oracle certification observe that has a SQL prerequisite. For case in point, the SQL examination I took in excess of a ten years ago was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That take a look at has been retired for years, but could nonetheless be used for the 12c observe.

While the articles of the two examinations is very equivalent, there are a handful of discrepancies. The two 1Z0-051 and 1Z0-061 consist of forty-1 subject areas. Of those, 30-six are popular to each examinations. This usually means the tests have about 88% commonality by topic rely. The past area of the 11g examination (Generating Other Schema Objects) was taken out from the examination in the 12c version. The subjects included in that area are:

• Create very simple and elaborate sights
• Retrieve details from views
• Produce, manage, and use sequences
• Produce and maintain indexes
• Develop non-public and public synonyms

For the 1Z0-061 examination, Oracle College included a new ‘Introduction’ section with the subsequent four subjects:

• Explain the attributes of Oracle Database 12c
• Describe the salient attributes of Oracle Cloud 12c
• Reveal the theoretical and bodily elements of a relational databases
• Explain Oracle server’s implementation of RDBMS and item relational databases administration procedure (ORDBMS)

They also included one more subject to the “Running Tables making use of DML statements” area:

• Truncate information

I have to say that I am really let down with Oracle University’s determination to put TRUNCATE (which is a DDL procedure) less than a segment exclusively about DML statements. This is not something that tends to make feeling in a test designed for people today who are new to SQL. I am sure that OU would be heartbroken to find out of my disapproval.

The 1Z0-061 test has nine much more queries than 1Z0-051 (75 vs 66) and a marginally bigger passing score (65% vs 60%). This does not necessarily indicate that the take a look at is more durable to move, though. The subject areas that have been extra are types that are possible to have issues that are far more easy than the topics that ended up taken off. OU has a certain goal proportion of candidates that they want to pass just about every take a look at on a very first try. If they elevated the passing score, it was simply because they felt the up-to-date examination experienced easier thoughts.

I have to say that deciding on a person check around the other is really a toss-up. The 11g test is not especially dated and all of the matters are nonetheless suitable. There may be a little little bit of prolonged-expression gain in acquiring the 12c examination on your report somewhat than 11g, only because 12c will be close to right after 11g is retired. However, 11g is at the moment the regular databases utilised in generation environments. Quite handful of providers will have moved to 12c but. In addition, none of my businesses have inquired (or cared) about the certain checks I took to attain my Oracle certifications. Decide on the exam that can make the most perception to you and you can be assured that you are not earning a error. Whichever a person you choose, very good luck on the test.