E X A M   D I F F I C U L T Y • What to Know • Study Tips • Oracle8i DBA OCP Articles • Discussion Board Rate Exam DifficultyVery EasyEasyAverageHardVery Hard

Oracle’s Oracle 8i exam 1Z0-020, “Oracle8i: New Features for Administrators” is an upgrade exam to the Oracle 8i OCP (Oracle Certified Professional) certification for those who hold the Oracle 8 OCP certification. It is designed for mid to advanced level database personnel. The prerequisite for this exam is holding an Oracle 8 OCP certification.

This exam is moderately difficult and costs $125 USD. It may be taken from Thomson Prometric.

The pass score for this form-based multiple choice exam is 67%. There are 54 scored questions (“your exam may contain unscored questions in addition to the scored questions”) and the exam lasts 1.5 hours.

The topics covered by this exam include:

• Java in the Database
• Optimizer and Query Improvements
• Summary Management
• Indexes and Index-Organized Tables
• Partitioning Improvements
• LOBs
• Oracle Universal Installer: Migration and Upgrade
• Tablespace Management
• Database Resource Manager
• Manageability Enhancements
• Availability and Recoverability Enhancements
• Describe the functionality of LogMiner
• Features of NET8
• SQL*Plus, PL/SQL, and National Language Support Enhancements
• Database Security