New Certification Exam: "Oracle Database 12c: SQL Fundamentals" Released (1Z0-061)

Oracle Certification begins testing this week for the new Oracle Database 12c Administrator Certified Associate (OCA) certification. 

Testing for the Oracle Database 12c: SQL Fundamentals (1Z0-061) exam is now underway. Visit and register for exam 1Z0-061. You can get all preparation details, including exam objectives, number of questions, time allotments, and pricing on the Oracle Certification Website.

Earning the Oracle Database 12c Administrator Certified Associate (OCA) credential demonstrates that you carry the foundational knowledge and skills needed to administer the Oracle Database, and sets the stage for your future progression to Oracle Database 12c Administrator Certified Professional (OCP). With Oracle Database 12c, you will experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.

Be among the first to obtain this ground breaking new Oracle Certified Associate (OCA) certification by registering for this exam today.



As at time of post from UK this Graphic implies Beta 1z1-061 ... but if I am not mistake the exam has gone straight to production 1z0-061 as he text implies.

Currently seems to be scheduled proctored only, which IMHO is a good thing as the online 1z0-051 was too open to the temptation of abuse.

Posted by bigdelboy on August 01, 2013 at 02:00 PM PDT #

Ah - you're correct! This exam did not go to beta first. Good catch!


Posted by Brandye Barrington on August 02, 2013 at 11:04 AM PDT #

Should be fixed now.

Posted by Brandye Barrington on August 02, 2013 at 11:34 AM PDT #

What is the difference between 1Z0-061 test and 1Z0-051?
Are both test valid pre req for 1Z0-062 (OCA?)

Posted by Jabba on August 06, 2013 at 06:16 AM PDT #

Hi Jabba,
Yes, both exams are valid pre-reqs for 062. 051 is based on 11g and 061 is based on 12c.

Brandye Barrington

Posted by Brandye Barrington on August 06, 2013 at 11:06 AM PDT #

Can someone please advice on what exams to take for Oracle Developer?
I had OCP certification (Application Developer 8i) -- 2002 but from 2005 have gone on to Java, C++ and PHP.


Posted by guest on August 06, 2013 at 04:00 PM PDT #

You can visit our website at and get a list of all available certifications. There are several Java certifications available that my interest you.

Brandye Barrington

Posted by Brandye Barrington on August 16, 2013 at 02:06 PM PDT #


i want to give the 1z0-061 exam ... can anyone suggest me how should i prepare for dis exam regarding books and type of question ?

Posted by guest on October 12, 2013 at 11:49 PM PDT #

Questions are multiple choice. On the Oracle Certification website, you'll see recommended training for this exam. You'll also see exam topics so that you can prepare for the topics that will be on the exam. Oracle Press does not yet have a guide specific to this exam, but they do have 12c books available. That might be a good resource.

Brandye Barrington

Posted by Brandye Barrington on October 14, 2013 at 01:40 PM PDT #

please can someone help me out. i just want to start learning oracle but do not know where to start. i had in mind to get certified as a database administrator. Can i go for oracle 11g?

Posted by guest on October 31, 2013 at 07:05 AM PDT #

You can go for 11g. I suggest that you start by having a look at our Oracle Certification Website at

Brandye Barrington

Posted by Brandye Barrington on November 04, 2013 at 12:45 PM PST #

would any one advice me on 1 or 2 books to prepare for the exam
1Z0-028 (oracle Database Cloud Administrators )
thanks a lots ,

Posted by guest on November 18, 2013 at 01:19 PM PST #

You may want to ask this question on the Certification Forum You could also check on Oracle Press Books

Brandye Barrington

Posted by Brandye Barrington on November 18, 2013 at 02:21 PM PST #

Hii I had scheduled my exam for 1Z0-061,but prepared it from 11g materials .Will It be good to give this exam or shud I go for 11g(1Z0-051)...Please help me on this.

Posted by guest on November 27, 2013 at 08:25 AM PST #

I am an oracle developer . Will 1z0-061 help me please . My certifications are old . I am OCA and OCP in oracle version 9i . I got my certs way back in 2004 . Does Oracle have developer track OCA in 12c version ? I think the second exam after 1z0-061 is only for DBAs. Kindly clarify.
Kindest regards .

Posted by S ARCOT on December 13, 2013 at 12:54 AM PST #

If you are an Oracle Developer, you may be more interested in these certifications Oracle Developer is not versioned.

Brandye Barrington

Posted by Brandye Barrington on December 13, 2013 at 02:10 PM PST #

Hello. As I can see 051 and 061 almost have no differences between them (SQL standarts hasn't changed a lot as well). Even more - 061 doesn't have a chapter about creating other schema objects, such indexes, etc.

And both are valid for OCA 11g, 12c certification. What was the point just to clone exam?

Posted by Alexey Zhukov on January 07, 2014 at 12:13 PM PST #

i am a fresher in IT industry....i have no idea regarding certifications till now....i want to start a new it good enough to start a OCA Oracle database 12c SQL fundamentals exam?

Posted by Ravindra on January 08, 2014 at 01:15 AM PST #

@Alexey, yes the exams are very similar. Both exams are valid to fulfill the SQL exam requirement for 11g and 12c OCA.

@Ravindra, 12c DBA OCA is a good place to start. Once you pass the SQL Fundamentals exam (1Z0-061), you will go on to 1Z0-062 to complete the OCA certification. You can get more information from our website Good luck with your certification path.

Brandye Barrington

Posted by Brandye Barrington on January 10, 2014 at 10:05 AM PST #

I am interested in doing OCA examination and I have good knowledge in 11g .Can I go ahead with 12c ? and also please let me know if there is any discount for students .

Posted by Mit on January 24, 2014 at 12:53 PM PST #

Hi Mit,
I suggest that you have a look at the 12c exam topics to see where the gaps are. I also suggest that you carefully consider your choice. Maybe get a 12c book to determine the differences between 11g and 12c.

Brandye Barrington

Posted by Brandye Barrington on January 27, 2014 at 01:04 PM PST #

Hey...if anybody could tell me if the Oracle 12c certification could be done by a beginner or I have to start from 11g ??

Posted by guest on March 22, 2014 at 10:52 AM PDT #

You can begin with 12c. You would begin with the OCA certification

Brandye Barrington

Posted by Brandye Barrington on March 24, 2014 at 12:52 PM PDT #

Hi ,

I have passed below exam

I had not attempted 1z0-033 exam. As 1z0-033 exam has retired.
I found new version of this exam is available as given below from your blog (

1Z0-033 Oracle9i Database: Performance Tuning =>(1Z0-063 Oracle Database 12c: Advanced Administration, 1Z0-053 Database 11g: Administration II or 1Z0-043 Database 10g: Administration II)

After that I cleared 1z0-053 and 1z0-050 .

Still certview is not showing my 9i/10g/11g OCP certification. Please help me what I do next to get my all 9i/10g/11g OCP Certifications.

Thanks & Regards
Amit Srivastava

Posted by Amit Srivastava on March 31, 2014 at 10:42 AM PDT #

Unfortunately, by skipping the 033 exam, you have not completed a full OCP certification.

For 9i OCP, you would have needed 007, 031, 032, 033 as well as a 9i training course.

I see that you passed the upgrade exams for 10g and for 11g, but those certifications were not awarded because you never completed your 9i OCP certification.

At this time, you have 9i DBA OCA, but you do not have 9i, 10g and 11g DBA OCP. Soon, we will be releasing a new path that will allow 9i DBA OCAs to upgrade to 12c. Stay tuned to this blog for more info on that.

From where you are now, if you'd like to achieve 10g and 11g OCP certification, you will need to pass exams 042 and 043, and take a 10g training course to get the 10g DBA OCP, then you will be automatically upgraded to 11g DBA OCP because you have already passed 050.

Alternatively, you could skip 10g and obtain 11g DBA OCP by passing exam 052 and taking an 11g traning course.

Brandye Barrington

Posted by Brandye Barrington on April 03, 2014 at 12:46 PM PDT #

i am an oracle sql developer.i am planning for an oca for the first time in my career and i am a queries are:

1.)is it better to go with 11g(1z0-051)or 12c(1z0-061) or expert(1z0-047)?

2.) i have an oracle 11g database access at present, is 12c available for free download for me to practise?

3.)what books and materials do you people(seniors) suggest to help me clear the exam?

4.)i also wanted to know where can i get model questions not dumps so that i can prepare myself for the standard of certification questions?

Posted by guest on May 23, 2014 at 03:59 AM PDT #

You can find the answers to most of your questions on the Oracle Certification Forum Matthew Morris is a prominent poster on the forum and he has actually written an article about your question #1. You should find the link to the article in the forum.

I believe that you can download the 12c database. You can also ask that question on the forum - where to download.

You can find book recommendations on the Forum. You can also find relevant books on the Oracle Press Books site

You can find legitimate practice test questions at Kaplan SelfTest is our authorized practice exam provider. Please do not ask for or use dumps. Dumps are actually illegal and are considered cheating. I realize that using dumps is very prevelant in some regions and we try to educate as widely as we can about these. Dumps are also notoriously bad information.

Good luck on your exams!
Brandye Barrington

Posted by Brandye Barrington on May 27, 2014 at 11:56 AM PDT #

thanks Brandye for your valuable information.
i am also very strictly against dumps and i also mentioned that in the query.

Posted by guest on June 10, 2014 at 05:29 AM PDT #

Please let me know:
can I register for 1Z0-062 exam after passing IZ0-051 exam or I have to pass 1Z0-061 exam before going for 1Z0-062?

Posted by guest on June 13, 2014 at 10:49 AM PDT #

You can pass either 051 or 061 before going to 062.

Brandye Barrington

Posted by Brandye Barrington on June 24, 2014 at 09:09 AM PDT #


I have 3yrs of relavant experience working as a technical support.Now, I am planning to change my domain for career growth and get in dba administrator. So, is OCA certification is best option to start dba associate jobs? And I am confused which one to choose to do DBA 11g or 12c? If i do 11g will that be valid or shall i go ahead by 12c. I want to know job point of view. As you know to be one out of hundred we need to have special certifications. So should i go with 12c. In bangalore everyone says 11g is enough to do reason is here no institute providing training on 12c. I am totally confussed and I dont want to spend money on useless thing .Experts please suggest. If i were a fresher then no problem but as I have 3yrs of experience as technical support the two things running on my mind before choosing any course i.e 1) Will I get good hike from my current package after doing OCA. 2) Which version should i take training and certified so that I be updated..

Posted by Pratik on October 17, 2014 at 10:43 AM PDT #

There is some good discussion on this topic on our Oracle Certification Forum The short answer is that it depends on where you are and what the job market is like. In order to get to DBA OCP certification, you'll need to start with OCA.

In addition to having a look at the Oracle Certification Forum, I suggest that you have a look through our website

Brandye Barrington

Posted by Brandye Barrington on October 21, 2014 at 02:24 PM PDT #

i am a newcomer in it world.i want to have oca certification on oracle.but in my city there are no institutes to provide a training on this.i read oracle 12c book.but i really need the sample question papers of the exams.please inform me about the books where i get the sample papers of 1z0-061 and 1z0-062 to practice.

Posted by guest on December 20, 2014 at 09:59 PM PST #

You can get practice tests from There are also a few good books available. You can go to the Oracle Certification Forum and search for books that other test takers have recommended.

Good luck on your path!
Brandye Barrington

Posted by Brandye Barrington on December 23, 2014 at 12:21 PM PST #

Im a Junior Oracle Developer which exam myb be good for me between

Oracle Database 12c: SQL Fundamentals 1Z0-061 or
Oracle Database 11g: SQL Fundamentals I 1Z0-051 or
Oracle Database SQL Expert 1Z0-047

Posted by guest on January 19, 2015 at 10:50 PM PST #

i wrote 1z0-061 exam and failed... i was not well prepared. After how many days gap can i write the same exam again? how many attempts can be made?

Posted by guest on January 24, 2015 at 06:12 PM PST #

Go to the Oracle Certification Forum and search for posts by Michael Morris. He has an article on the differences between these three exams that will be helpful for you.

Regarding retake policy, you must waith 14 days before you can take the same exam again.

Brandye Barrington

Posted by Brandye Barrington on January 26, 2015 at 08:15 AM PST #

If you fail 1z0-061 exam, can you write 1z0-051 before 14 days without counting as retake?

Posted by guest on March 18, 2015 at 08:26 PM PDT #

Technically, yes - you could take a different exam within the 14-day wait period for retakes. If you are prepared for the other exam.

Brandye Barrington

Posted by Brandye Barrington on March 19, 2015 at 07:12 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Official blog of the Oracle Certification Program


« March 2015