Certification insights, news and tips
from the Oracle Certification Program.

Oracle Database 12c SQL Certification? Am I an Associate or Expert?

Eva Chase
Global, Sr. Marketing Manager

you know which exam you should take now that we just released the new Oracle
Database 12c SQL Certified Associate exam?

If not, use
this as a guide:

  1. This
    new exam
    1Z0-071 is a midpoint knowledge exam. It’s
    proctored, so its cost is the same as our other proctored exams. Pass this exam and get an Oracle Certified Associate badge.
  2. If
    you are already an Oracle Certified Expert having passed the 1Z0-047
    exam, there is no need to take 1Z0-071 too. The Oracle Certified Expert exam is harder and it covers a lot, so deep subject
    knowledge is needed to pass.
  3. If you're not ready to attempt full certification, we have two SQL Fundamental exams; 1Z0-051
    for 11g and 1Z0-061 for 12c. They are not proctored so you don’t become Oracle
    certified after passing. They have a lower
    cost and are not as difficult.

Are you ready to become
an Oracle
Database 12c SQL Certified Associate

Test Your
Oracle Database 12c SQL skills with three practice exam questions
In Oracle
Magazine May-June 2016 issue.  See Inside OCP, to test your depth of knowledge of
SQL and how to use it with Oracle Database 12c

Ready to test?  Schedule your exam at http://www.pearsonvue.com/oracle/ and join the close to 2 million others who’ve become
Oracle certified!

Join the discussion

Comments ( 10 )
  • james Saturday, July 16, 2016

    Requested for training materials.

  • Brandye Barrington Wednesday, July 20, 2016

    Hi James,

    Are you planning to pursue this certification? Good luck on your journey!


    Brandye Barrington

  • Vinicius Lima Wednesday, January 25, 2017

    I'm interested to take the 1Z0-047 exam. But I'm worried that it is a bit old and will not be valid anymore. Does this risk exist?

  • Brandye Barrington Thursday, February 2, 2017

    Hi Vinicius,

    The 047 exam is retiring soon. That is something to keep in mind if you are pursuing this certification. There is not an Expert level replacement for this exam, but the Oracle Database 12c SQL Certified Associate certification is a good alternative.


    Brandye Barrington

  • Roshanth Monday, March 6, 2017

    Hi Brandye Barrington,

    Can you please let me know when the exam 1Z0-047 is going to retire. I am preparing for that exam now.



  • Brandye Barrington Monday, March 6, 2017


    This exam is scheduled to retire on July 31, 2017. You can find all retirement information on our website here https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=206&sc=OUNV160511P00006C0001. You may want to consider the newer SQL OCA exam instead.


    Brandye Barrington

  • Addie Wednesday, July 25, 2018
    Hi dear,

    i'm new to database, so i was googling about database and its vendors so i got oracle and i hope its the best one in the world yet.
    would you mind guiding me with certification path for my first step to this world? thanks for not giving me any website address and find myself coz i already have done it and still confused. so it'll be better if you tell me which exam to start with and what study materials to use.

    Thanks & regards
  • Keertana Friday, July 27, 2018
    Hi Brandye,

    I have completed the 1Z0-047 certification 4 years back.
    I am planning for another certification with Oracle.
    I have understood that I need not take the IZO O71 exam as I have already finished O47 certification.
    COuld you please help me to find the next level of certification to be done. I am a oracle developer.

    One more information I need about my certification is that I dont have the certificate details with me and I couldnt retrieve it as I forgot my Pearson IDs. Kindly help.
  • Brandye Barrington Thursday, August 30, 2018
    Hi Keertana,
    Yes, you can use your 047 exam results to fulfill the SQL exam requirement in this path. You do not need to take another SQL exam.

    Brandye Barrington
  • Haseeb Monday, September 3, 2018
    Dear Keertana,

    Did you took the exam ? I am going for it soon. Would you please help me out on it. I just wanna know the difficulty level of 1Z0-071 . Is it really hard to pass i saw some old exam pdf to get an idea they seems confusing...

    Haseeb Gillani
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.