OCA/OCP Oracle Database 11g All­in­One Exam Guide with CD­ROM

by John Watson, Roopesh Ramklass, Bob Bryla

This Oracle Press certification exam guide covers all of the exam objectives on the Administration I and II exams and on the SQL Fundamentals exam. Ideal as both exam guide and on-thejob reference, this book includes examples, practice questions, lab questions, and a summary in each chapter. The book includes 150+ practice questions, and the CD-ROM contains three full practice exams, with three more available for download, plus an e-book. This is the most comprehensive preparation tool available for the OCA and OCP exams. About The Author: John Watson, OCP, is a consultant with BLP Management Consultants. He taught for Oracle University in South Africa. Table of Contents Part I: Oracle Database 11g Administration Chapter 1. Architectural Overview of Oracle Database 11g Chapter 2. Installing and Creating a Database Chapter 3. Instance Management Chapter 4. Oracle Networking Chapter 5. Oracle Storage Chapter 6. Oracle Security Part II: SQL Chapter 7. DDL and Schema Objects Chapter 8. DML and Concurrency Chapter 9. Retrieving, Restricting, and Sorting Data Using SQL Chapter 10. Single-Row and Conversion Functions Chapter 11. Group Functions Chapter 12. SQL Joins Chapter 13. Subqueries and Set Operators Part III: Advanced Database Administration Chapter 14. Configuring the Database for Backup and Recovery Chapter 15. Back Up with RMAN Chapter 16. Restore and Recover with RMAN Chapter 17. Advanced RMAN Facilities Chapter 18. User-Managed Backup, Restore, and Recovery Chapter 19. Flashback Chapter 20. Automatic Storage Management Chapter

1084 pages, Paperback

First published September 25, 2009

About the author

John^^^^Watson

Librarian Note: There is more than one author by this name in the Goodreads data base.

Reviews

[Nohelia · Rating 4 out of 5]

It's an OK book to get the basic knowledge you need for the exams, but you'll certainly need to practice with exam dumps, create your own environment for practicing and consult the official documentation.

The areas the info was lacking the most was: globalization, resource manager and scheduler.