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

Doug Stuns (Author), Biju Thomas (Author)

Book Description

Series: Ocp: Oracle8i Study Guides | Publication Date: November 2000

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, Architecture & 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.

Editorial Reviews

From the Back Cover

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

About the Author

Doug Stuns , OCP, has been an Oracle DBA for more than a decade. He has worked for Oracle in consulting and education roles for five years and is the founder and owner of SCS, Inc., an Oracle-based consulting company.

Biju Thomas has more than six years of Oracle database management and application development experience. He has written articles for in both Oracle Magazine and Oracle Internals.

Product Details

• Hardcover: 845 pages
• Publisher: Sybex Inc; 1st edition (November 2000)
• Language: English
• ISBN-10: 0782126839
• ISBN-13: 978-0782126839
• Product Dimensions: 9.3 x 7.9 x 2.3 inches
• Shipping Weight: 4.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #3,469,736 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Great Study Guide, March 4, 2001

By 

Diego Salvo (Porto Alegre, RS Brasil) - See all my reviews

This review is from: OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide (Hardcover)

After reading the whole book I can say this is a great study guide for Oracle8i and for the certification too. There are some erros on the book (Sintax Erros), but anyway the book helped me to get certified so I will give 5 stars intead of 4. The book doesn't explain why the things are that way (as Oracle Press books do), just explain that are that way. The questions that are on the book after each chapter are extremely easy comparing to the certification exams. The Oracle sample questions are also easy comparing to the certification, but the ocp.exe exam that is on the book's CD is at the same level or the certification. If you know everything on the book, and did all the questions and sample questions, I think you are ready to pass on the Certification Exam.

6 of 6 people found the following review helpful:

4.0 out of 5 stars Excellent part 1 (Architecture ...) Bad part 2 (Backup...), May 14, 2001

By 

Marco A. Nunes (São Paulo, SP Brazil) - See all my reviews
(REAL NAME)   

This review is from: OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide (Hardcover)

I have passed the 1z0-023 (architecture...) easily only using that book. But I haven't passed the 1z0-025 (backup ...) whith that book because the 2'nd part is very unreal in relation with the actual exam.

3 of 3 people found the following review helpful:

3.0 out of 5 stars Don't Read BACKUP & Recovery Part if you want to pass., July 15, 2001

By 

Sameh Shawkat Odeh "ODEH SAMEH" (Qatar) - See all my reviews
(REAL NAME)   

This review is from: OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide (Hardcover)

I've previous experience in DBA before reading this book. The Architecture & Administration PART was excellent and cover around 95% of the test questions, but the second part Backup & Recovery was full of errors and not useful at all and doesn't cover more than 25% of the test questions, and only cover the titles of the test!!!!