OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide

OCP is Oracle's certification program for database administrators, application developers, and financial consultants.

The DBA (database administrator) track is the most popular, with more than 8,000 DBAs being certified each year. Sybex's OCP DBA Study Guides provide complete coverage of exam objectives for the five exams in the DBA track: SQL and PL/SQL, Database Administration, Backup & Recovery, Performance Tuning, and Network Administration. The books are fully up-to-date for Oracle8i and include all the new features of Sybex's best-selling Study Guides. The companion CDs contain exclusive self-testing software.

The DBO (database operator) exam is a new offering from Oracle, which prepares students for the full DBA track. It is fully supported by Oracle's partners: Sun, Novell, Compaq, and HP. Sybex's Study Guide provides complete coverage of the exam objectives and includes a companion CD with exclusive self-testing software. Author Lance Mortensen is the author of many best-selling MCSE Study Guides.

Here's the book you need to prepare for the Oracle8i Architecture & Administration and Backup & Recovery exams (1Z0-023 and 1Z0-025). Written by Oracle8i experts, this affordable and comprehensive Study Guide provides:

• Full coverage of all exam objectives—all the information you need
• Practical information on administration, backup, and recovery techniques in a real-world Oracle8i environment
• Hundreds of challenging review questions, in the book and on the CD
• Leading-edge exam preparation software, including a testing engine and electronic flashcards

Authoritative coverage of all objectives for both exams, including:

• Installing and managing Oracle Server
• Using control files
• Understanding logical and physical database structures
• Understanding segments and storage structures
• Managing tables, indexes, and constraints
• Managing users and security
• Using data utilities
• Understanding recovery structures and processes
• Using Recovery Manager for backups and recovery
• Performing physical backups without Recovery Manager
• Performing a complete recovery without Recovery Manager
• Performing an incomplete recovery with archiving
• Using export and import utilities
• Using troubleshooting utilities
• Creating and maintaining a recovery catalog
• Setting up and using a standby database