Oracle 8 Certified Professional DBA Certification Exam Guide

Part 1 Introduction to SQL and PL/SQL: selecting data from Oracle; advanced data selection in Oracle; creating an Oracle database; creating other database objects in Oracle; introducing PL/SQL. Part 2 Database administration: basics of the Oracle database architecture; managing the physical database structure; managing database objects 1; managing database objects 2; managing database usage; data loads and national language support. Part 3 Backup and recovery workshop: backup and recovery architecture and motives; backup and recovery configuration and usage; using recovery manager for backup and recovery; database failure and recovery; advanced topics in data recovery. Part 4 Tuning workshop: introducing database tuning; tuning database applications; tuning OS and memory utilization; tuning disk utilization; tuning other areas of Oracle. Part 5 Net8 administration: overview of Net8 for client and server; names, intelligent agent and MTS; connection manager, troubleshooting and security. Part 6 Oracle8i new features for administrators.