Oracle University Releases New PL/SQL Certification: Oracle Advanced PL/SQL Developer Certified Professional (OCP)

Oracle University Releases New PL/SQL Certification: Oracle Advanced PL/SQL Developer Certified Professional (OCP)Oracle University has released the new Oracle Advanced PL/SQL Developer Certified Professional (OCP) certification.

Testing began April 1, 2009 for the new "Oracle Database 11g Advanced PL/SQL" certification exam (1Z0-146) at Prometric testing centers worldwide. This exam tests the proficiency and knowledge in key areas of PL/SQL design and tuning to ensure the most efficient interface with the database and other applications. This 68-question exam is the only requirement to upgrade the Oracle PL/SQL Developer OCA to Oracle Certified Professional (OCP). Test candidates are allowed as long as 90 minutes to complete the exam, and a minimum score of 65% is required to pass. Score details and completion status are available immediately at the end of the exam.

Although training is not a mandatory requirement for this certification, it is highly encouraged to best prepare for the certification. Oracle offers the Oracle Database 11g: Advanced PL/SQL training course (#D52601GC10). In this class, students learn through real-life examples and hands-on lab activities to use advanced features of program design, packages, cursors, extended interface methods, large objects and collections as well as to write powerful PL/SQL programs. Additionally, students are taught programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks. Course attendees will receive a downloadable eKit containing the training materials for this course.

Certification exam candidates can register now online at Prometric.



This is one good thing that I recently saw here. It's a good course even someone with-- Oracle PL/SQL Developer Certified Associate can apply for this course and get Advanced certified. And also someone can take the whole course at once. Have heard that this is a great program and after reading about it, it sounds interesting.

Posted by Debi Prasad on April 23, 2009 at 09:20 PM PDT #

Thanks Debi! -Harold

Posted by Harold Green on April 23, 2009 at 11:47 PM PDT #

Hi, Is there any online course material from Self Test Software for taking up 1Z0-146 exam. If so, please let me know, I am not able to find it. Thanks, Sri

Posted by Sri on July 08, 2009 at 07:55 AM PDT #

Anyone know where I could get the e-book for self-preparation into 1Z0-146 exam ? And I looking the test simulation tools too e.g. Testking, Quest Self Test Software (STS), but haven't find any product of 1Z0-146 test simulation.

Posted by Ryan on September 10, 2009 at 07:33 PM PDT #

Yes, Would appreciate if anyone can post the link to e-book for preparation of this certification.

Posted by Rinku on November 13, 2009 at 04:57 AM PST #

The good news is YES, Self Test Software is developing a practice test to help you prepare for the Oracle 1Z0-146 exam. The bad news is we don't have it on the shelves just yet. Our Oracle expert just completed his analysis of the test objectives and development schedule. We should have a practice test available shortly after the holidays.

Posted by A.Rotella on November 17, 2009 at 04:03 AM PST #

I want to know which university can offer me a Oracle certified course in United Kingdom and mode of entry with the fees.

Posted by Wasiu Babatunde Adewale on December 29, 2009 at 09:14 PM PST #

Hi Wasiu, You can find training locations on the Oracle University website at You can also search for Oracle courses on this site and find out where the courses are being offered and what the cost is in your local currency. For further questions on Oracle University Courses, please contact your local Oracle University rep. You can find the appropriate phone number on our website at For further questions about Oracle Certifications and Certification Exams, you can contact Regards, Brandye

Posted by Brandye Barrington on January 07, 2010 at 12:09 AM PST #

Dear Wasiu , Thank you for contacting the Oracle Certification Program Team. For all your queries regarding training and course requirements please visit our website or your local Oracle University representative for further guidance. You can also call a representative at 1.800.529.0165 where they can best assist you with questions on training/courses. Please continue to email us with your questions and concerns at Regards, OCP Team

Posted by Paul Sorensen on January 15, 2010 at 01:11 AM PST #

Hello people, can any 1 help me for 1z0-146 exam in a way like by sending some e books. Thanx,

Posted by rutvi on June 28, 2010 at 08:36 PM PDT #

I have completed OCA on database administration not in PL/SQL. am i also eligible to take up this exam...

Posted by Navin on March 10, 2011 at 07:04 PM PST #

Navin, You are eligible to take this exam, however you will need to also take some additional steps. If you are DBA OCA, you will need to follow the path below for Advanced PL/SQL Developer OCP - Pass exam 147 or 144 - Pass exam 146 Regards, Brandye Barrington

Posted by Brandye Barrington on March 16, 2011 at 01:58 AM PDT #

hi guys.. rite nw doin Oracle 11g can any-1 advise me 4rm whr 2 gt the materials required 4 oca . wantd 2 go as a plsql developer not getting the idea how 2 enroll myslf for oca exam...

Posted by Moonis Rahman on July 03, 2011 at 03:18 AM PDT #

You can find information on the recommended training for each exam on our website at Beyond that, you can search the Certification Forum for book recommendations. Others have posted helpful suggestions there. You can register for all Oracle Certification exams at

Brandye Barrington

Posted by brandye barrington on July 05, 2011 at 02:14 AM PDT #

Hello Sir,

I am planning to have my carrer as a DBA, i have a fairly good idea about SQL. what are necessary exams that i have to pass for getting OCA ?

As a fresher what is the scope for OCA ?

I request you to put your views on this.


Posted by guest on October 03, 2011 at 08:19 PM PDT #

I would like to know if there is a cost on taking this exam and if it is, how much will it be in American Dollars? I'm interested on this but I wouldn't like to continue if I don't know an average price...
Thanks in advance!

Posted by guest on March 25, 2013 at 03:24 PM PDT #

You can find the cost of this exam in your local currency on our website. Click on the link above that will take you to the exam page, where you will find the details of the exam such as cost, recommended training and exam topics.

Brandye Barrington

Posted by Brandye Barrington on March 27, 2013 at 02:00 PM PDT #

sir,its good to do OCA AND OCP Certification being as fresher?

Posted by sanket katariya on August 22, 2013 at 07:18 AM PDT #

Yes, the OCA certification is designed for Freshers. Then we recommend that you gain some work experience or get lots of practice before you go for OCP.

Brandye Barrington

Posted by Brandye Barrington on August 23, 2013 at 03:05 PM PDT #

Hi Sir, do you have an efficient resource for OCA exam? thanks. and let me know. planning to get the certification next yr.

Posted by Catherine on October 01, 2013 at 02:07 AM PDT #

Hi Catherine,
The best resource is to take the training. Depending on which OCA exam you plan to take, there may be good books written about it. You can search on our Certification Forum for more info.

Brandye Barrington

Posted by Brandye Barrington on October 09, 2013 at 01:31 PM PDT #


Do you recommend any book/guide for 1Z0-146 oracle certification?


Posted by Bhavik on November 20, 2013 at 01:38 AM PST #

Hi Bhavik,
You can check on the Certification Forum to see if other candidates have suggested books to help prepare for this exam.

You can find the exam topics on the website here

Brandye Barrington

Posted by Brandye Barrington on November 20, 2013 at 02:03 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed

« July 2016