Oracle9i Certified DBA

How to get Oracle9i Certification?

 Oracle Education has three certification programs for Oracle DBAs in Oracle9i.

Oracle Certified Associate (OCA)
Oracle Certified Professional (OCP)
Oracle Certified Master (OCM)

Each level of certification includes 2 tests each. In this article we discuss only the OCA and OCP certifications, for information on OCM visit Oracle Education OCM.

Regular Path

Follow this path if you’re not certified in any of previous versions of Oracle database. The certifications prior to Oracle9i are Oracle7.3 OCP, Oracle8.0 OCP and Oracle8i OCP.

Oracle Certified Associate (OCA)

To earn the Oracle9i Database Administrator Certified Associate credential, two exams are required; the first one can be taken via the Internet, while subsequent exams must be taken in a proctored environment.

Exam #1Z0-007 Introduction to Oracle9i: SQL (Online exam availableExam #1Z0-001 Introduction to Oracle: SQL and PL/SQL

Exam #1Z0-031 Oracle 9i Database: Fundamentals I

Oracle Certified Professional (OCP)

To earn the Oracle9i Database Administrator Certified Professional credential, you must complete OCA, take two exams and attend any one of Oracle9i trainings from Oracle Education.

Pass Oracle Certified Associate
Oracle9i Database: Fundamentals II (#1Z0-032)
Oracle9i Database: Performance Tuning (#1Z0-033)
You must take one of the following training offered by Oracle education. The training class could be instructor led in-class or instructor led online.
Introduction to Oracle9i: SQL
Oracle9i Database Fundamentals I
Oracle9i Database: Fundamentals II
Oracle9i Database Performance Tuning
Oracle9i Database New Features for Administrators
For exemptions to the one class requirement and to find out more, be sure to read Hands-on course requirement

 

Exam Number

Exam Title

Questions Correct

Scored Questions*

Passing %

Duration

1Z0-001

Introduction to Oracle: SQL and PL/SQL

39

57

68%

2 hours

1Z0-007

Introduction to Oracle9i: SQL

40

57

70%

2 hours

1Z0-031

Oracle9i Database: Fundamentals I

44

60

73%

1.5 hours

1Z0-032

Oracle9i Database: Fundamentals II

49

63

77%

1.5 hours

1Z0-033

Oracle9i Database: Performance Tuning

38

59

64%

1.5 hours

 

Upgrade Path

If you’re certified in any of the previous versions of Oracle database as OCP, you can take one exam and become Oracle9i certified OCP. For this path, there is no training class requirement. The exams available are:

Upgrade from Oracle7.3 OCP
Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs
Upgrade from Oracle8.0 OCP
Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs
Upgrade from Oracle8i OCP
Exam #1Z0-030 Oracle9i Database: New Features for Administrators

Exam Number

Exam Title

Questions Correct

Scored Questions*

Passing %

Duration

1Z0-030

Oracle9i Database: New Features for Administrators

37

53

70%

1.5 hours

1Z0-035

Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs

58

84

69%

2 hours

 

Preparing for the Exam

If you’ve no access to Oracle9i database, the first thing to do is to download a copy of Oracle9i database from OTN. You have to register and agree to the terms and conditions. The membership to OTN is free.
Verify the exam requirements and score requirements at Oracle Education
Review the exam objectives
Prepare for the exam using study guides, sample questions and Oracle documentation

Exam Resources

Books

 Click here for Oracle9i Certification Books from Sybex and Osborne

Oracle Documentation

Administrators Guide
Concepts Guide
9i New Features Guide
Performance Tuning Guide and Reference
Database Reference
Installing and Managing Sample Schemas
SQL Reference
SQL Plus Users Guide and Reference
Utilities Guide
Installing Oracle9i on Windows

 Sample Questions & Resources

DBDomain.com
CIWManiac.com
Cert21.com
Boson Software
Oracle Notes
Self-test Software Download
NY Oracle Users Group Presentation
Yahoo Groups - Oracle_OCP_Study_Materials
Yahoo Groups - oracle_certprep

 

GOOD LUCK!

Search BijooS.com Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to webmaster@bijoos.com. © The scripts, tips and articles appearing on BijooS.com cannot be reproduced elsewhere without the prior permission from the webmaster.