The first of the Oracle certification exams to go into production is: Oracle Database : SQL Fundamentals. Oracle University has made this test in production almost simultaneously with the removal of the much older test : Introduction to Oracle9i SQL . However, version 11g SQL Fundamentals exam, 1z0 – 051 , is still available. Having two equivalent tests in production leads to great confusion among the candidates . In this article I discuss the two tests , what is different between them, and how to choose one over the other .
Or will satisfy the requirement for SQL “Oracle Database 11g Administrator Certified Associate ” or tracks “Oracle PL / SQL Developer Certified Associate ” . The requirement also can be satisfied by passing the SQL : Oracle Database SQL Expert . However, an examination is much more difficult than 1Z0 – 051 is an option that should only be considered if has worked extensively with Oracle SQL . This article focuses on the SQL Fundamentals exam.
12c and 11g SQL Fundamentals I exams are almost identical in their essence and satisfied the requirements for Oracle certifications . Oracle does not require the use of SQL Fundamentals 12c 12c in finding the track or track DBA 11g DBA exam in that version . Any review of Oracle SQL (including retired ) can be used for any Oracle certification path that has a requirement for SQL . For example , SQL test I took it for more than a decade was Introduction to Oracle : SQL and PL / SQL . This test has been retired for years, but could still be applied to the track 12c
While the content of the two tests are very similar, there are differences. Both 1Z0-051 contains forty-one subjects. Of these, thirty-six are common to both examinations. This means that the tests are around 88% in the number of community discussion. The last section of the exam 11g (creation of other schema objects), withdrew from the trial version 12c. The topics covered in that section are:
- Create simple and complex views
- Retrieve data from views
- Create, maintain, and use sequences
- Create and maintain indexes
- Create private and public synonyms
For the 1Z0-051 exam, Oracle University added a new ‘Introduction’ section with the following four topics:
- Describe the features of Oracle Database 12c
- Describe the salient features of Oracle Cloud 12c
- Explain the theoretical and physical aspects of a relational database
- Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)
- They also added one more topic to the “Managing Tables using DML statements” section:
- Truncate data
Oracle University ‘s decision to put TRUNCATE (which is a DDL operation ) in a section specifically DML . This is not something that makes sense in a test designed for people who are new to SQL . I’m sure OU would be heartbroken to know my disapproval .
1Z0 -051 has more than nine questions 1Z0 – 051 (75 vs 66 ) and a passing score slightly higher ( 65 % vs 60%). This does not necessarily mean that the test is more difficult to overcome , however. The topics that have been added are the questions you might have are simpler than the issues that have been deleted . OU has a certain target candidates who want to pass all tests on the first attempt percentage. If they raised the passing score is because they felt it had updated test questions easier.
I must say that the choice of one test over the other is really a toss . The 11g exam is not particularly dated and all issues are still relevant. There may be some long-term benefit in view of the examination 12c disk instead of 11g , simply because it will be around 12C after retiring 11g. However, 11g is currently the standard database used in production environments.
Very few companies have moved to 12c yet. Furthermore, none of my employers have asked ( or care ) about the specific tests I took to earn my certifications Oracle. Select the test that makes more sense for you and you can be sure that you are not making a mistake. Whoever you choose good luck for the test.
Matthew is an experienced DBA and developer . Has Oracle DBA certifications for versions 7 , 8i , 9i , 10g and 11g , Oracle Expert certifications for SQL , SQL Tuning and Application Express, is a developer and advanced Oracle PL / SQL Certified Professional.
Oracle 1z0-051 Oracle Database 