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

  • News
    September 22, 2016

Prepare Now For Your SQL OCA Certification - NEW

Brandye Barrington
Sr. Program Manager

Earn a core OCA credential on your path to Database Administrator or PL/SQL Developer certifications, by passing exam 1Z0-071 Oracle Database SQL.

Released earlier this year, this certification fills a gap in the offerings that fulfill the SQL prerequisite in core Database Administrator and PL/SQL Developer paths. Until now, these offerings included two non-proctored SQL fundamentals exams (1Z0-051 and 1Z0-061) that do not result in certification by themselves and a more in depth SQL Expert exam (1Z0-047) that covers topic areas that may not show up very often in the day to day activities of a SQL Developer. SQL knowledge is essential to the Database Administrator role as well as that of the PL/SQL Developer. The new Oracle Database SQL Certified Associate credential gives a broader, more comprehensive view of SQL without dipping into more difficult, seldom-used features.

Passing this exam is a win/win if you are pursuing a path that includes a SQL requirement. You earn two valuable certifications.

Even if your plans don't currently include an additional layer of certification, this credential proves fluency in and a solid understanding of SQL language, data modeling and using SQL to create and manipulate tables in an Oracle Database.


Join the discussion

Comments ( 11 )
  • Sayed Wasiullah Friday, October 7, 2016

    Hello I am Sayed Wasiullah from Kabul,Afghanistan

    I would like to do oracle certification online.

    Please give me complete information about the mentioned

    Course and books.

    Thanks &Regards

    Sayed Wasiullah

  • Brandye Barrington Thursday, October 20, 2016

    Hi Sayed,

    You will first need to determine which certification you wish to pursue. You can see waht certifications are available at certification.oracle.com. Click on the certification title that interests you, click on it and you can see the requirements to earn that certification, including any recommended training.

    Please let us know if you need further assistance with this,


    Brandye Barrington

  • VISHNU Thursday, October 20, 2016

    Hi Brandye,

    I'm from India.

    I'm planning to do 1Z0-071 followed by 1Z0-146.

    Does the 1Z0-146 require any other additional certifications other 1Z0-071?

    If doing 071 and 146 is possible could you please help me with any additional requirements for doing these two certifications.

    I'm hoping that with these two I can be an OCP.


    Vishnu M

  • guest Friday, October 21, 2016


    If you want to earn Oracle Advanced PL/SQL Developer Certified Professional, you'll need to:

    1. Hold Oracle PL/SQL Developer Certified Associate and

    2. Pass exam 1Z0-146

    To earn Oracle PL/SQL Developer Certified Associate, you'll need to:

    1. Pass 1Z0-071 and

    2. Pass exam 1Z0-144


    Brandye Barrington

  • Siva Swaroop Monday, December 19, 2016


    i would like to be certified in oracle.I have a few questions below.

    1. Do i need to do OCA in SQL,before doing OCA in PL/SQL.

    2.How to prepare for the certification.(Guidance and tips).

  • Brandye Barrington Tuesday, December 20, 2016

    Hi Siva,

    I suggest that you start by visiting our website certification.oracle.com and viewing the list of available certifications. Select the certification you're interested in pursuing and you will be able to see the requirements to earn that certification.


    Brandye Barrington

  • Marie Moore Thursday, October 5, 2017

    I have never used SQL; can I pass 1Z0-071: Oracle Database 12c SQL?

    Thank you,
  • Brandye Barrington Thursday, October 5, 2017
    Hi Marie,
    That depends on how much you know about SQL. You'd be the best judge of that. You can see the exam topics on the exam page http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-071&intcmp=WWOUCERTBLOGPOSTPNFY092216.

    Have a look at the topics and take the practice test. See where your knowledge gaps are and figure out how confident you feel with the topics.

    Brandye Barrington
  • Mahantgouda Tuesday, May 29, 2018
    Hi , i am planning to start prepare for exam Oracle Database SQL 1Z0-071 . can someone help me with dumps and way to start preparing for exam. And if any tips/good dumps to get start .And if ypou have already cleared or attempted can you help me how much effort it really takes so that it can help me to estimate my daily efforts .Thanks in advance
  • Brandye Barrington Wednesday, June 20, 2018
    You probably are not aware of this, but using dumps is cheating. We strongly recommend that you use the Oracle University training resources available - training, exam prep seminar package.

    Brandye Barrington
  • Asha katol Thursday, September 19, 2019
    Thanks for the Information on OCAD.It was very helpful.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.