The first of the Oracle 12c certification checks to enter output is 1Z0-061: Oracle Databases 12c: SQL Fundamentals. Oracle College set this examination into creation just about on the identical time with the retirement of the much more mature check 1Z0-007: Introduction to Oracle9i SQL. Having mentioned that, the 11g version of the SQL Fundamentals examination, 1Z0-051, continues to be accessible. Buying two equal exams in manufacturing results in a good sum of confusion amongst certification candidates. On this article I’ll discover the 2 checks, what’s numerous involving them, and the way to choose one explicit in extra of the opposite.

Presumably will fulfill the SQL prerequisite for the “Oracle Databases 11g Administrator Certified Affiliate” or “Oracle PL/SQL Developer Licensed Affiliate” tracks. The SQL prerequisite can be contented by passing 1Z0-047: Oracle Database SQL Specialist. Nonetheless, 1Z0-047 is a noticeably more durable examination than both 1Z0-051 or 1Z0-061. That is an choice that ought to solely be deemed you probably have labored with Oracle SQL extensively. This write-up focuses on the SQL fundamentals exams.

The 11g and 12c SQL Fundamentals examinations are just about an identical in situations of content material materials coated and requirements happy for Oracle certifications. Oracle doesn’t want you to make use of the 12c SQL Fundamentals when pursuing the 12c DBA preserve monitor of or the 11g check for the DBA monitor in that launch. Any Oracle SQL check (comparable to retired sorts) can be utilized for any Oracle certification observe that has a SQL requirement. For instance, the SQL examination I took over a decade again was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That examination has been retired for yrs, however might proceed to be utilized for the 12c observe.

While the content material materials of the 2 checks is fairly equal, there are a pair distinctions. Equally 1Z0-051 and 1Z0-061 have forty-a single subjects. Of people, thirty-6 are widespread to the 2 exams. This implies the exams have about 88% commonality by topic depend. The ultimate phase of the 11g examination (Producing Different Schema Objects) was taken out from the examination within the 12c version. The subjects lined in that portion are:

• Construct quite simple and complicated sights
• Retrieve data from views
• Develop, protect, and use sequences
• Produce and protect indexes
• Make personal and neighborhood synonyms

For the 1Z0-061 examination, Oracle College included a brand new ‘Introduction’ portion with the next 4 issues:

• Clarify the capabilities of Oracle Databases 12c
• Clarify the salient choices of Oracle Cloud 12c
• Exhibit the theoretical and bodily options of a relational database
• Describe Oracle server’s implementation of RDBMS and object relational databases administration system (ORDBMS)

Additionally they added one explicit further matter to the “Managing Tables using DML statements” space:

• Truncate information

I’ve to say that I’m fairly upset with Oracle College’s conclusion to set TRUNCATE (which is a DDL operation) below a portion particularly about DML statements. This isn’t one thing that can make notion in a check designed for people who’re new to SQL. I’m completely positive that OU could be heartbroken to seek out out of my disapproval.

The 1Z0-061 examination has 9 much more questions than 1Z0-051 (75 vs 66) and a touch bigger passing score (65% vs 60%). This doesn’t primarily indicate that the check is tougher to go, though. The issues which have been included are sorts which can be prone to have queries which can be much more clear-cut than the subjects that had been being taken off. OU has a specific goal proportion of candidates that they need to go each examination on a to start out with attempt. In the event that they lifted the passing score, it was because of the truth they felt the up-to-date examination had simpler points.

I’ve to say that selecting one check above the opposite is genuinely a toss-up. The 11g examination is just not specifically dated and the entire subjects are nonetheless acceptable. There may very well be a minor little little bit of extended-phrase revenue in getting the 12c examination in your report alternatively than 11g, solely as a result of 12c shall be throughout simply after 11g is retired. Having mentioned that, 11g is now the everyday database utilized in creation environments. Very a number of organizations may have moved to 12c nonetheless. As well as, none of my employers have inquired (or cared) in regards to the exact exams I took to amass my Oracle certifications. Resolve on the check that makes probably the most feeling to you and you’ll be assured that you’re not making a slip-up. Whichever 1 you resolve on, nice luck on the examination.