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

  • November 7, 2018

Make Every Exam Count - Take the SQL Exam That Gives You OCA Certification

Brandye Barrington
Sr. Program Manager

We receive support requests every week from candidates asking for the certificate for passing the non-proctored exam Oracle Database 12c: SQL Fundamentals | 1Z0-061. Each time, we explain that this exam alone does not result in certification. Candidates must pass the next exam in their Oracle Certified Associate (OCA) path to earn a certification and receive a digital badge. This unpleasant surprise results in disappointed candidates who want to receive something tangible for passing a certification exam.  

Don't face this same disappointment. 

With the imminent retirement of Oracle Database 12c: SQL Fundamentals | 1Z0-061 (November 30, 2019), now is the perfect time to switch your focus to the exam that proves fluency in and a solid understanding of SQL language, data modeling and using SQL to create and manipulate tables in an Oracle Database, AND results in a SQL OCA certification

Passing the exam Oracle Database SQL | 1Z0-071 earns you the Oracle Database SQL Certified Associate credential and also fulfills the SQL requirement in the Oracle Database Administrator and Oracle PL/SQL Developer Certified Associate paths. 

We call this 'killing 2 birds with 1 stone," or getting double the benefit from a single action.

RELATED:  Prepare Now For Your SQL OCA Certification - NEW

The SQL Requirement

SQL knowledge is essential to the Database Administrator and PL/SQL Developer roles. Upon its release, exam 1Z0-071 filled a gap in the offerings that fulfill the SQL prerequisite in these paths. This offering has gone on to become the standard. The Oracle Database SQL Certified Associate credential gives a broader, more comprehensive view of SQL, and results in OCA certification. This certification also better fits the defined job role.

Let's evaluate each exam further:

  Oracle Database SQL | 1Z0-071 Oracle Database 12c: SQL Fundamentals | 1Z0-061
Cost $245 USD $125 USD
Delivery Proctored at a test center Non-proctored at your own location
Certificate Oracle Database SQL Certified Associate  Not until you pass the next exam in your OCA path
Relevance Aligns more closely with defined job role Retiring November 30, 2019

While exam 1Z0-061 costs less and is more convenient to take, the benefit of earning a certification for passing the 1Z0-071 exam far outweighs the lower price and convenient delivery format. Choosing the 1Z0-071 exam on your way to Database Administrator or PL/SQL Developer OCA makes every exam in your path count equally, e.g. 2 exams = 2 certifications. 

RELATED: Navigate Oracle SQL Certification: Quickly and Easily

Follow the path that makes the most sense! Prepare now for Oracle Database SQL | 1Z0-071. 

Join the discussion

Comments ( 7 )
  • waseem akram Friday, April 12, 2019
    i'm planning to write sql exam 1z0071 , can anyone explain me how to apply and when to apply , where I have to write exam , how to select the exam center, and retake policy and exam fees
  • Brandye Williams Barrington Monday, June 10, 2019
    Hi Waseem,
    First, I'd like to apologize for the late reply. You can go to pearsonvue.com/oracle to register for an exam. You'll be able to select an exam center, date, and time to take your exam.

    You'll also see the exam fee in your region on the Pearson VUE website.

    If you happen to fail the exam on the first attempt, you'll need to wait 14 days before retaking the exam, and you'll pay full cost for the 2nd attempt.

    Brandye Barrington
    Oracle Certification
  • Brandye Williams Barrington Monday, June 10, 2019
    Hi Waseem,
    You can find testing center locations, book the exam, select a time and date, and see the cost of the exam in your local currency at www.pearsonvue.com/.

    If you do not pass the exam on your first attempt, you will need to wait 14 days before retaking the exam and the exam cost for retakes is the full cost.

    Brandye Barrington
    Oracle Certification
  • joyce Friday, June 28, 2019
    hi i did an exam 1z0-071 and failed.how do i retake?do i have a free retake? and if not so how do i pay again,thank you
  • Brandye Barrington Friday, June 28, 2019
    Hi Joyce,
    Unless you purchased an exam prep seminar package, which contains an exam voucher and free retake, or unless you purchased your voucher through a special promotion, you would not have a free retake.

    You will need to register for the exam and pay full cost.

    Brandye Barrington
  • Danielle Wednesday, March 25, 2020
    Is it mandatory to take the 1Z0-071 to have your OCA certification? Or Can you be alright with just the OCA certification?
    I have take the OCA but not the sql test.
  • Brandye Barrington Thursday, March 26, 2020
    Hi Danielle,
    If you want to earn the DBA OCA certification, you will need to pass a SQL exam. So yes, you will need to take 071.

    The only version that does not require a SQL exam is the 2019 Database Administrator, but there is not an OCA level - only OCP level and you take Admin I and Admin II exams to get the OCP cert.

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