About
Oracle Certification Program
Available Certification Exams Printer View
Select an Exam number to view full details.
Please note that the only upgrade paths available are the ones outlined below. If there is not a path shown below from your specific version of certification to the version that you wish to obtain, then you may be required to complete more than one exam to achieve the desired version of certification. For instance, if you are an Oracle8 DBA OCP and you wish to upgrade to 10g DBA OCP, you must pass the exam (1Z0-020) to upgrade from Oracle 8 DBA OCP to Oracle8i DBA OCP and then also pass the exam (1Z0-045) to upgrade from Oracle8i DBA OCP to Oracle 10g DBA OCP. The 10g DBA OCP credential will not be awarded to Oracle8 DBA OCPs who only pass the 1Z0-045 exam. If you are not sure of your upgrade path, please contact ocpexam_ww@oracle.com and we will be glad to assist you.
——————————————————————————–
Database Middleware Applications Linux
Database
Exam Number Exam Name Exam Objectives Duration Number of
Questions Passing Score Training Register
1Z0-001 Introduction to Oracle: SQL® and PL/SQL™ Objectives 120 minutes 57 68% Introduction to Oracle 8i: SQL and PL/SQL – ILO
Introduction to Oracle8i: SQL and PL/SQL Self-Study CD Course (NETg)
1Z0-007 Introduction to Oracle9i SQL®
Exam available oonline Objectives 120 minutes 52 71% Introduction to Oracle9i: SQL
or Oracle Database 10g: Introduction to SQL
Introduction to Oracle9i: SQL Self-Study CD Course (NETg Oracle)
1Z0-010 Oracle8: New Features for Administrators Objectives 90 minutes 50 72%
1Z0-020 Oracle8i: New Features for Administrators Objectives 90 minutes 54 67% Oracle8i: New Features for Administrators
OCP – 8.0 to 8i Upgrade Exam Prep
1Z0-030 Oracle9i New Features for Administrators™ Objectives 105 minutes 60 50% Oracle9i: New Features for Administrators
Oracle9i New Features for Administrators Self-Study CD Course (NETg)
1Z0-031 Oracle9i Database: Fundamentals I™ Objectives 120 minutes 60 73% Oracle9i Database: Fundamentals I
Oracle9i DBA Fundamentals I Self-Study CD Course (NETg Oracle)
1Z0-032 Oracle9i Database: Fundamentals II ™ Objectives 120 minutes 63 73% Oracle9i Database: Fundamentals II
Oracle9i DBA Fundamentals II Self-Study CD Course (NETg Oracle)
1Z0-033 Oracle9i Database: Performance Tuning™ Objectives 120 minutes 65 72% Oracle9i Database: Performance Tuning
Oracle9i Database Performance Tuning R2 Self-Study CD Course (NETg Oracle)
1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Objectives 120 minutes 84 69% Oracle9i Database: New Features for Administrators
More Information
1Z0-036 Managing Oracle9i on Linux™ Objectives 120 minutes 59 57% Managing Oracle on Linux
1Z0-040 Oracle Database 10g: New Features for Administrators™ Objectives 105 minutes 60 73% Oracle Database 10g: New Features for Administrators
Oracle Database 10g: New Features for Administrators Release 2
View additional 10g New Features Preparation.
More Information
1Z0-041 Oracle Database 10g 2 Day DBA Assessment Exam™
Exam available oonline Objectives 60 minutes 60 75% Oracle Database 10g: 2 Day DBA
1Z0-042 Oracle Database 10g: Administration I Objectives 120 minutes 84 68% Oracle Database 10g: Administration Workshop I
More Information
1Z0-043 Oracle Database 10g: Administration II Objectives 90 minutes 70 70% Oracle Database 10g: Administration Workshop II
More Information
1Z0-045 Oracle Database 10g DBA New Features for Oracle8i OCPs Objectives 2 hours 78 73% Oracle Database 10g: New Features for Oracle8i DBAs
More Information
1Z0-046 Oracle Database 10g: Managing Oracle on Linux for Database Administrators Objectives 105 minutes 63 65% Oracle Database 10g: Managing Oracle on Linux for DBAs
1Z0-047 1Z0-047 Oracle Database SQL Expert Objectives 120 minutes 70 66%
Passing score subject to change. View Details
Oracle Database 10g: Introduction to SQL
OR
Oracle Database 11g: Introduction to SQL
OR
Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II
Exam 047 has been validated against Oracle Database 10g and Oracle Database 11g. Training on either version will be appropriate preparation.
1Z0-048 Oracle Database 10g R2: Real Application Clusters for Administrators Objectives 120 minutes
Total for both sections 63
for both sections combined. RAC Administration Section: 60%
Cluster Management Section: 60%
There are two sections to this exam. Both sections of the exam MUST be passed in order the pass the exam. Oracle Database 10g: Real Application Clusters
OR
Oracle Database 10g: RAC for Administrators Release 2
NOTE: The exam is based on Oracle Database 10g R2. Those who prepared using the Oracle Database 10g: Real Application Clusters training for Release 1 will need to ensure they are familiar with changes between R1 and R2.
1Z0_050 Oracle Database 11g: New Features for Administrators Objectives 105 minutes
79 61%
Beta exam score reports will be posted on www.prometric.com/oracle on February 5, 2008. They will be mailed to candidates soon after. Oracle Database 11g: New Features for Administrators
1Z0-051 Oracle Database 11g: SQL Fundamentals I
Exam available oonline Objectives 120 minutes 70 60% Oracle Database 11g: SQL Fundamentals I or
Oracle Database 11g: Introduction to SQL
Note: The Oracle Database 11g: Introduction to SQL course covers additional topics that are not covered on the exam.
Exam 051 has been validated against Oracle Database 10g and Oracle Database 11g. Training on either version will be appropriate preparation.
1Z0-052 Oracle Database 11g: Administration I Objectives 90 minutes 70 66% Oracle Database 11g: Administration I
1Z1-053
Beta Exam Oracle Database 11g: Administration II Objectives 3-3.5 hrs 180-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam Oracle Database 11g: Administration Workshop II
1Z0-055 Oracle Database 11g: New Features for 9i OCPs Objectives 120 minutes 84 61% Oracle Database 11g: New Features for Administrators
AND
Oracle Database 10g: New Features for Administrators
10g OCM Oracle Database 10g Administrator Certified Master Exam Objectives 2 days More information Performance Based Exam Scoring Recommended Training and Preparation
1Z1-054
Beta Exam Oracle Database 11g: Performance Tuning Objectives 3-3.5 hrs 180-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam Oracle Database 11g: Performance Tuning
Middleware
Exam Number Exam Name Exam Objectives Duration Number of
Questions Passing Score Training Register
1Z0-001 Introduction to Oracle: SQL® and PL/SQL™ Objectives 120 minutes 57 68% Introduction to Oracle 8i: SQL and PL/SQL – ILO
Introduction to Oracle8i: SQL and PL/SQL Self-Study CD Course (NETg)
1Z0-007 Introduction to Oracle9i SQL®
Exam available oonline Objectives 120 minutes 52 71% Introduction to Oracle9i: SQL
or Oracle Database 10g: Introduction to SQL
Introduction to Oracle9i: SQL Self-Study CD Course (NETg Oracle)
1Z0-101 Develop PL/SQL Program Units Objectives 120 minutes 57 68% Develop PL/SQL Program Units
Oracle9i: Develop PL/SQL Program Units Self-Study CD Course (NETg)
1Z0-130 Oracle Forms Developer Release 1 to Rel. 6/6i New Features Objectives 120 minutes 60 57%
1Z0-131 Build Internet Applications I Objectives 90 minutes 60 75% Oracle iDS Forms: Build Internet Applications I
Oracle iDS Forms: Build Internet Applications I (R6i) Self-Study CD Course (NETg)
1Z0-132 Build Internet Applications II Objectives 90 minutes 60 77% Oracle iDS Forms: Build Internet Applications II
Oracle iDS Forms: Build Internet Applications II (R6i) Self-Study CD Course (NETg)
1Z0-140 Oracle Forms Developer: New Features Objectives 90 minutes 44 64% Oracle9i Forms Developer: New Features
1Z0-141 Oracle Forms: Build Internet Applications Objectives 120 mniutes 69 75% Oracle9i Forms Developer: Build Internet Applications
Oracle Forms Developer 10g: Build Internet Applications
More Information
1Z1-146
Beta Exam Oracle Database 11g: Advanced PL/SQL Objectives 190 minutes 180-220 NA
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam Oracle Database 11g: Advanced PL/SQL
1Z0-147 Program with PL/SQL Objectives 90 minutes 66 77% Oracle9i: Program with PL/SQL
Oracle Database 10g: Program with PL/SQL
Oracle9i: Program with PL/SQL Self-Study CD Course (NETg Oracle)
1Z0-255 Hyperion Essbase 7.1.2 Consultant Objectives 180 minutes 129 68% Hyperion Essbase 7.1.2 Bootcamp
AND
Hyperion Essbase 7.1.2 For System Administrators
AND
Hyperion Essbase 7.1.2: Deploy Aggregate Storage Databases
All three courses are recommended for exam preparation
1Z0-263 Hyperion System 9 BI+ 9.0 Administrator Objectives 60 minutes 49 68% Hyperion BI+ 9.0 Installation and Administration
1Z0-264 Hyperion Essbase 9.3 Developer Objectives 60 minutes 51 72% Hyperion Essbase Analytics 9.3 Bootcamp
1Z0-265 Hyperion System 9 BI+ 9.3 Administrator Objectives 60 minutes 51 69% Hyperion BI+ 9.3 Installation and Administration
1Z0-301 Oracle9iAS: Basic Administration Objectives 90 minutes 83 63% Oracle9iAS Basic Administration
More Information
1Z0-311 Oracle Application Server 10g: Administration I Objectives 105 Minutes 66 71% Oracle Application Server 10g: Administration I
Oracle Application Server 10g Administration I Self-Study CD Course (NETg Oracle)
1Z0-312 Oracle Application Server 10g: Administration II Objectives 105 minutes 90 60% Oracle Application Server 10g: Administration II
The exam has been validated against Oracle Application Server 10g R2 [Version: 10.1.2.0.2]
Oracle Application Server 10g Administration II Self-Study CD Course (NETg Oracle)
Applications
Exam Number Exam Name Exam Objectives Duration Number of
Questions Passing Score Training Register
1Z0-108 Oracle WebLogic Server 10g System Administration Objectives 120 minutes 51 66%
Passing score subject to change. View Details BEA WebLogic Server 9/10: System Administration
BEA WebLogic Server 9/10: Advanced System Administration
BEA WebLogic Server 9/10: WebLogic Diagnostics Framework
BEA WebLogic Server 9/10: Performance Tuning
BEA WebLogic Server 9/10: Monitor and Performance Tuning
Note: The Oracle WebLogic Server courses will be released soon. When these courses are released, they will be the most updated versions of the recommended training for WebLogic Server System Administrator Certified Expert. Until the Oracle courses are released, the BEA courses above will prepare candidates for the exam.
Oracle WebLogic Server 10.3: System Administration (to be released January 2009)
Oracle WebLogic Server 10.3: Advanced System Administration (to be released February 2009)
1Z0-109 Oracle WebLogic Server 10g Developer Objectives 120 minutes 73 70%
Passing score subject to change. View Details BEA WebLogic Server 9.0: Develop EJBs in Eclipse
BEA WebLogic Server 9/10: Program J2EE Servlets and JSPs in Eclipse
1Z0-110 Oracle Weblogic Portal 10g Developer Objectives 120 minutes 70 70%
Passing score subject to change. View Details BEA WebLogic Portal 9/10: Develop Enterprise Portals
OR
BEA WebLogic Portal 9/10: Develop Enterprise Portals – LWC
OR
Oracle WebLogic Portal 10g R3: Develop Enterprise Portals (to be released in February 2009)
1Z0-114 Oracle SOA Foundations, Adoption and Implementation Objectives 120 minutes 81 66%
Passing score subject to change. View Details Organization, Planning & Architectural Consideration for SOA
OR
Organization, Planning & Architectural Considerations for SOA – LWC
SOA Architectural Concepts and Design Principles
OR
SOA: Architectural Concepts and Design Principles LWC
1Z0-200 11i E-Business Suite Essentials for Implementers
Exam available oonline Objectives 90 minutes 64 55% 11i E-Business Suite Essentials for Implementers
This exam is based on Oracle E-Business Suite 11i.10.
Oracle 11i e-Business Suite Essentials for Implementers Self-Study CD Course (NETg Oracle)
1Z0-202 Siebel 8 Consultant Exam Objectives 120 Minutes 67 64% Siebel 8.0 Essentials AND Implementation Case Study (Siebel 8.0)
OR
Siebel 8 Core Consultant Course
*One of the above training paths is required for Siebel 8 Consultant Certification. Please see the Siebel 8 Consultant Certified Expert track page for more information on the certification requirements.
1Z0-204 Oracle E-Business Suite R12: E-Business Essentials
Exam Available Oonline Objectives 90 minutes 65 61%
Beta exam score reports were posted on www.prometric.com/oracle on July 9, 2008 Oracle E-Business Suite R12: E-Business Essentials
1Z1-206
Beta Exam Oracle E-Business Suite R12: System Administration Objectives 3-3.5 hrs 180-220 questions NA
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam R12 Oracle Applications System Administrator Fundamentals
1Z0-207 Oracle Communications Billing and Revenue Management: Pricing Objectives 90 minutes 62 75% Billing and Revenue Management Version 7 Business Essentials (OR Billing and Revenue Management Version 7 Technical Essentials)
Billing and Revenue Management Version 7 Pricing and Rating
1Z0-208 Oracle Communications Billing and Revenue Management: Server Developer Objectives 90 minutes 56 75% Billing and Revenue Management Version 7 Technical Essentials
Billing and Revenue Management Version 7 Server Developer
1Z0-209 Oracle Communications Billing and Revenue Management: System Administrator Objectives 90 minutes 61 75% Billing and Revenue Management Version 7 Technical Essentials
Billing and Revenue Management Version 7 System Administration
1Z0-211 Oracle General Ledger 11i Fundamentals Objectives 90 minutes 66 60% 11i General Ledger Management Fundamentals Ed 3.1
This exam is based on Oracle E-Business Suite 11i.10.
Oracle Applications 11i General Ledger Fundamentals Self-Study CD Courses (NETg Oracle)
1Z0-212 Oracle Payables 11i Fundamentals Objectives 90 minutes 62 60% 11i Oracle Payables Fundamentals Ed 3
This exam is based on Oracle E-Business Suite 11i.10.
1Z0-213 Oracle Receivables 11i Fundamentals Objectives 90 minutes 76 55% 11i Oracle Receivables Fundamentals
This exam is based on Oracle E-Business Suite 11i.10.
1Z1-215
Beta Exam Oracle E-Business Suite R12: General Ledger and Payables Fundamentals Objectives 3-3.5 hrs 200-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam. R12 Oracle General Ledger Management Fundamentals
R12 Oracle Payables Management Fundamentals
1Z1-216
Beta Exam Oracle E-Business Suite R12: General Ledger and Receivables Fundamentals Objectives 3-3.5 hrs 200-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam R12 Oracle General Ledger Management Fundamentals
R12 Oracle Receivables Management Fundamentals
1Z1-218
Beta Exam PeopleSoft Enterprise 9 HRMS Fundamentals Objectives 3 – 3.5 hours 180 – 220 NA
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam Human Resources Rel 9
1Z0-221 Oracle Inventory Management 11i Fundamentals Objectives 90 minutes 64 62% 11i Inventory Management Fundamentals Ed 2
This exam is based on Oracle E-Business Suite 11i.10.
1Z0-222 Oracle Purchasing 11i Fundamentals Objectives 90 minutes 73 60% 11i Oracle Purchasing Fundamentals Ed 1
This exam is based on Oracle E-Business Suite 11i.10.
1Z0-223 Oracle Order Management 11i Fundamentals Objectives 90 minutes 68 64% 11i Oracle Order Management Fundamentals Ed 2
This exam is based on Oracle E-Business Suite 11i.10.
1Z1-225
Beta Exam Oracle EBS R12: Inventory and Purchasing Fundamentals Objectives 210 minutes 200-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam R12 Oracle Inventory Management Fundamentals
R12 Oracle Purchasing Fundamentals
1Z1-226
Beta Exam Oracle EBS R12: Inventory and Order Management Fundamentals Objectives 210 minutes 200-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam R12 Oracle Inventory Management Fundamentals
R12 Oracle Order Management Fundamentals
1Z0-228 PeopleSoft Enterprise 9 General Ledger Objectives TBD TBD TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam General Ledger Rel 9
1Z0-231 Oracle 11i/2.6 Implementing Workflow Objectives 90 minutes 72 59% 11i/2.6 Implement Oracle Workflow Ed 3
This exam is based on Oracle Workflow 2.6.
1Z0-232 Oracle 11i System Administration Objectives 105 minutes 56 60% 11i System Administrator Fundamentals Ed 3
This exam is based on Oracle E-Business Suite 11i.10
Oracle 11i System Administrator Fundamentals for 11i10 Self Study CD Course (Netg Oracle)
1Z0-233 11i Install Patch and Maintain Oracle Applications Objectives 90 minutes 61 65% 11i Install Patch and Maintain Oracle Applications Ed 5.1
This exam is based on Oracle E-Business Suite 11i.10.
1Z0-235 Oracle 11i Applications DBA Fundamentals I Objectives 120 minutes 68 70% Oracle9i Database Administration Fundamentals I
Oracle9i Database Administration Fundamentals II
1Z0-236 Oracle 11i Applications DBA Fundamentals II Objectives 120 minutes 66 72% Oracle9i Database Administration Fundamentals II
Oracle9i Database Performance Tuning
1Z0-238 Oracle EBS R12: Install, Patch and Maintain Applications Objectives TBD TBD TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam R12 Oracle: Install, Patch and Maintain Oracle Applications
1Z0-241 PeopleSoft Application Developer I: PeopleTools & PeopleCode Objectives 105 minutes 80 64% PeopleTools I Rel 8.48
PeopleTools II Rel 8.48
PeopleCode Rel 8.44
1Z0-242 PeopleSoft Application Developer II: Application Engine & Integration Objectives 120 minutes 85 65% Application Engine Rel 8.48
Integration Tools Rel 8.48
1Z1-244
Beta Exam Oracle EBS R12: Advanced Supply Chain Planning Objectives 3-3.5 hrs 180-220 TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam R12 Oracle Advanced Supply Chain Planning Fundamentals
1Z0-257 Hyperion Financial Management 4.1 Consultant Objectives 120 minutes 104 69% Hyperion Financial Management 4.1: Create & Manage Applications
Hyperion Financial Reporting 9.0 for Financial Management
1Z0-259 Hyperion Planning 4.1 Consultant Objectives 90 minutes 100 73% Hyperion Financial Reporting 9.0 for Essbase and Planning
Hyperion Planning 4.1: Create and Manage Applications
1Z0-262 Hyperion Planning 4.1 Administrator Objectives 60 minutes 34 66% Hyperion Planning 4.1: Create and Manage Applications
Hyperion Financial Reporting 9.0 for Essbase and Planning
1Z0-271 Hyperion Financial Management 9.3 Administrator I & II Objectives 105 minutes 89 69% Hyperion Financial Management 9.3: Create & Manage Applications
Hyperion Financial Reporting 9.3 for Financial Management
1Z0-272 Hyperion Planning 9.3 Administrator I & II Objectives 105 minutes 82 66% Hyperion Planning 9.3: Create and Manage Applications
Hyperion Financial Reporting 9.3 for Essbase and Planning
1Z0-273 Hyperion Financial Management 4.1 Administrator I & II Objectives 90 minutes 57 68% Hyperion Financial Management 4.1: Create & Manage Applications
Hyperion Financial Reporting 9.0 for Financial Management
1Z0-615 Siebel 7.7 Consultant Core Exam Objectives 120 minutes 70 70% Core Consultant Course(Siebel 7.7)
OR
Essentials(Siebel 7.7) AND Implementation Case Study(Siebel 7.7)
*One of the above training paths is required for Siebel 7.7 Consultant Certification. Please see the Siebel 7.7 Certified Consultant Track page for more information on the certification requirements.
1Z0-620 Siebel 7.7 Application Developer Professional Core Exam Objectives 90 minutes 39 76% Analytics: Application Developer(Siebel 7.7)
Analytics: Advanced Application Developer(Siebel 7.7)
Due to the decreasing availability of the Siebel 7.7 Analytics courses, Oracle Certification will accept the Oracle BI courses toward Analytics certification. However, please remember that the Siebel 7.7 Analytics courses remain the best way to prepare for these exams and Oracle BI courses may not sufficiently help prepare candidates.
1Z0-630 Siebel 7.7 Server Architect Professional Core Exam Objectives 120 minutes 58 75% Analytics: Server Architect (Siebel 7.7)
Analytics: Advanced Server Architect (Siebel)
Due to the decreasing availability of the Siebel 7.7 Analytics courses, Oracle Certification will accept the Oracle BI courses toward Analytics certification. However, please remember that the Siebel 7.7 Analytics courses remain the best way to prepare for these exams and Oracle BI courses may not sufficiently help prepare candidates.
1Z0-640 Siebel 7.7 Data Warehouse Developer Professional Core Exam Objectives 120 minutes 50 78% Analytics: Data Warehouse Developer (Siebel 7.7)
Analytics: Advanced Data Warehouse Developer Ed 1
Due to the decreasing availability of the Siebel 7.7 Analytics courses, Oracle Certification will accept the Oracle BI courses toward Analytics certification. However, please remember that the Siebel 7.7 Analytics courses remain the best way to prepare for these exams and Oracle BI courses may not sufficiently help prepare candidates.
Linux
Exam Number Exam Name Exam Objectives Duration Number of
Questions Passing Score Training Register
1Z0-036 Managing Oracle9i on Linux™ Objectives 120 minutes 59 57% Managing Oracle on Linux
1Z0-046 Oracle Database 10g: Managing Oracle on Linux for Database Administrators Objectives 105 minutes 63 65% Oracle Database 10g: Managing Oracle on Linux for DBAs
1Z0-402 Enterprise Linux Fundamentals Objectives 120 minutes 87 57 Enterprise Linux: Linux Fundamentals
1Z0-403 Enterprise Linux System Administration Objectives 120 mins 113 62% Enterprise Linux: System Administration Ed 1
What companies provide Oracle Certification?
The following companies provide Oracle Certification:
Oracle Corporation
Oracle Corporations Certification is the most widely sought after and recognized of all available certifications. This FAQ will mainly concentrate on Oracle’s Certification tracks.
Brainbench Inc. (formerly Tekmetrics)
A new kid on the block offering Oracle E-certifications. Their certifications are not officially recognized by Oracle Corporation.
Test.com Inc.
On-line Testing Center with some Oracle tests. However, their certifications are not officially recognized by Oracle Corporation.
Chauncey Group International
Chauncey’s DBA certification was superseded by Oracle’s certification program. Chauncey does not offer any Oracle certifications anymore.
[edit] What official Oracle certification tracks are available?
Oracle Corporation Offers the following Oracle Certification Tracks:
Oracle Certified Associate (OCA)
Enables one to act as a junior team member working with database administrators or application developers.
Oracle Certified Professional (OCP)
OCP candidates have proven skills for managing a large scale database or developing robust applications that are deployed enterprise-wide.
Oracle Certified Master (OCM)
The highest level credential you can earn in the Oracle Certification Program. These people are senior level members of IT departments and are responsible for handling mission critical database systems and applications.
Internet Application Developer (Release 6 or 6i)
Oracle developers using Oracle iDS (Internet Developer Suite) Forms and Reports.
Oracle Java Developer (JDEV)
Developers using the Java platform. Oracle participates in the multi-vendor jCert Initiative.
PS: The Oracle Database Operator (DBO) track was discontinued on 31 March, 2002.
[edit] How hard are the exams?
That depends. If you know your stuff, they are quite easy. If you don’t, well, they are quite hard. The exams test stuff you really need to know. However, they do add some trick questions as well. Nevertheless, these should not scare you off as they don’t count that much anyway.
[edit] What training is required before one can take an exam?
Starting from Oracle 9i Oracle changed the requirements for some certification tracks to include training classes:
OCP – You need to attend one hands-on training class at Oracle University. See Oracle’s web site for a list of courses.
OCM – You need to attend two advanced training classes at Oracle University. See Oracle’s website for a list of courses.
All other tracks – Generally no courses required. It might be a good idea to attend some relevant courses before taking an exam, but poor people like me must often do without it.
See section: info about training events/opportunities.
[edit] How do I prepare for the exams?
First step is to go to http://www.oracle.com/education/certification and read the list of objectives per exam. There aren’t any questions that don’t fit one of those objectives. Make sure you know what’s on those objectives.
Note that all the questions are compiled from the official Oracle training guides one gets when attending an Oracle class (Instructor Led Course). It is advisable to get these guides by attending the Oracle training classes before taking any of the exams.
Lastly, use the software and practice. Don’t just read about a topic – implement it; break it; then fix it. There’s no better way to learn stuff than to fix something you broke yourself.
[edit] Where can one take these exams?
Testing for the Oracle exams is conducted at authorized Prometric testing centers worldwide. Use their on-line Test Center Locator to find the test center closest to you.
[edit] What is the format of the certification exams?
All exams are closed book exams. No written materials or notebook computers will be allowed in the testing area. All questions are either multiple choice, fill in the missing word or match these against those.
Testing is conducted by Thompson Prometric.
When an English test is delivered in a non-English speaking country, the test time might vary from what you see on this site.
[edit] How are exams scored?
It’s not like school where you have to get 60% or whatever. Previously all exam were scored on a 200-800 scale, with 620 as the passing score for all exams. With this scaling system, the number of points each question was worth varied between exams, and candidates could not compare their scores across exams.
Oracle has decided to abandon the scaled scores and instead report only the candidates’ raw scores.
[edit] Can one (during an exam) skip questions and answer them later in the exam?
Yes, you may mark certain question that you feel are difficult and review them at the end of the exam. After you clicked the submit button, the tool will tell you that you have marked questions and allow you to jump to them. Both marked and unmarked questions will be scored when finally submitting the exam.
[edit] Is it OK to guess answers or are these tests marked negatively?
The Oracle OCP exams are not scored negatively. This means that you can safely guess answers as no points will be deducted for incorrect answers.
It is best to check if you have actually answered ALL questions before completing the exam. If you are running short on time, just click any answer and move on. This way you will at least have a chance to get some of them right.
[edit] Do I have to pass one exam before I can write the next one?
No. You can write any exam in any order. You could even write Admin II, Admin I, SQL in that order if you wanted. They don’t follow on one after another, and you get your certificate when you pass all required exams.
[edit] What happens when one fails an exam?
If you fail a test you can re-write it after a minimum of 14 days, provided you do not write a particular test more than three times in a twelve-month period.
After each exam you will receive some diagnostic feedback with the test score report indicating the areas that need further study.
Failing one exam doesn’t affect any other exams though. If you fail SQL you can still write Admin I any time you want for example.
There is no discount price for re-taking an exam. The fee is the same as for the initial exam.
[edit] Where can one get sample questions for the Oracle exams?
One can buy test questions from companies like Self Test Software, Transcender and TestKing. However, even if you’re not going to buy any, it is still handy to download them as they normally include some free “sample” questions:
Buy practice tests from Self Test Software
Buy practice tests from Transcender
Oracle offers FREE downloadable assessment test on their Web site at http://www.oracle.com/education/certification (only selected exams).
PS: Please note that you can check if a test provider is legal on the following web address: http://www.testkingdumps.org
Books:
A sample test is provided as part of the book Advanced ORACLE Tuning & Administration chapter 15. The book is published by Oracle Press (ISBN 0-07-882241-6). Authors: Aronoff, Loney, and Sonawalla.
Get the book: Oracle DBA Exam Cram: Proven Techniques to Pass the Oracle Certified Professional Exam by Michael R. Ault (ISBN: 1576102629)
