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-023, “Oracle8i: Architecture and Administration” is a core requirement for the Oracle 8i OCP (Oracle Certified Professional) certification. It is designed for mid to advanced level database personnel. There is no specific prerequisite for this exam.

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

The pass score for this form-based multiple choice exam is 65%. There are 65 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:

• Oracle Architectural Components
• Getting Started with the Oracle Server
• Managing an Oracle Instance
• Creating a Database
• Creating Data Dictionary Views and Standard Packages
• Maintaining the Control File
• Maintaining the Redo Log Files
• Managing Tablespaces and Data Files
• Storage Structure and Relationships
• Managing Rollback Segments
• Managing Tables
• Maintaining Data Integrity
• Loading Data
• Reorganizing Data
• Managing Password Security and Resources
• Managing Privileges
• Managing Roles
• Using National Language Support