OCP: Oracle8i^TM DBA Architecture & Administration and Backup & Recovery Study Guide: Exams 1Z0-023 & 1Z0-025

by Doug Stuns; Biju Thomas

• ISBN13: 9780782152951
• ISBN10: 0782152953
• Format: eBook
• Copyright: 2006-02-01
• Publisher: Sybex

Summary

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.Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

Assessment Tests

OCP: Oracle8i Architecture & Administration

Oracle Overview and Architecture

Installing and Managing Oracle

Creating a Database and Data Dictionary

Control and Redo Log Files

Logical and Physical Database Structures

Segments and Storage Structures

Managing Tables, Indexes, and Constraints

Managing Users and Security

Data Utilities

OCP: Oracle8i Backup & Recovery

Backup and Recovery Considerations

Oracle Recovery Structures and Processes

Oracle Backup and Recovery Configuration

Physical Backup without Oracle Recovery Manager

Complete Recovery without Recovery Manager

Incomplete Oracle Recovery with Archiving

Oracle Export and Import Utilities

Additional Recovery Issues

Oracle Utilities for Troubleshooting

Oracle Recovery Manager

Oracle Recovery Manager Catalog Creation and Maintenance

Backups Using RMAN

Restoration and Recovery Using RMAN

Oracle Standby Database

Oracle8i Architecture & Administration Practice Exam

Oracke8i Backup & Recovery Practice Exam

Glossary

Index

Table of Contents provided by Publisher. All Rights Reserved.