Oracle Database 10g OCP Certification All-In-One Exam Guide

by Damir Bersinic, John Watson

Overview

The Most Authoritative OCA/OCP Exam Guide Available

Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you’ll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to:

• Install Oracle Database 10g and create a database
• Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL
• Create and manage database user accounts
• Configure Oracle Networking
• Manage shared servers
• Monitor, tune, and troubleshoot a database
• Handle database backup, restore, and recovery
• Use Oracle Recovery Manager and Oracle Flashback
• Configure and manage security
• Use Automatic Storage Management and Resource Manager
• Automate administrative tasks

Included on the CD-ROM

Electronic Practice Test engine with two full practice exams

Complete electronic book

Product Details

ISBN-13:	9780071502306
Publisher:	McGraw Hill LLC
Publication date:	10/03/2005
Series:	Oracle Press
Sold by:	Barnes & Noble
Format:	eBook
Pages:	926
File size:	39 MB
Note:	This product may take a few minutes to download.

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

John Watson (UK) OCP DBA 8.0, 8.i, & 9i, 10g, 11g, Interrnet Application Server Administrator, and certified on Managing Oracle on Unix, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. John taught the DB10g New Features course, the DB10g Manageability and Performance seminars. He validated hundreds of OCP 10g New Features exam questions and contributed to the course material for all the 10g courses. John is the author of numerous articles on technology.

Table of Contents

Part I: Oracle Database 10g Administrative I Exam Chapter 1: Basic Oracle Concepts Chapter 2: Installing Oracle Database 10g Chapter 3: Creating an Oracle Database Chapter 4: Interfacing with the Oracle Database Chapter 5: Managing Oracle Processes Chapter 6: Managing Oracle Storage Structures Chapter 7: Administering Database Users Chapter 8: Managing Database Objects Chapter 9: Manipulating Database Data Chapter 10: Programming Oracle with PL/SQL Chapter 11: Securing the Oracle Database Chapter 12: Configuring Oracle Networking Chapter 13: Managing Shared Servers Chapter 14: Managing Database Performance Chapter 15: Monitoring Oracle Chapter 16: Managing Undo Chapter 17: Dealing with Locking Chapter 18: Configuring the Database for Backup and Recovery Chapter 19: Backing Up an Oracle Database Chapter 20: Recovering Oracle Databases Chapter 21: Managing Globalization in Oracle Databases Part II: Oracle Database 10g Administrative II Exam Chapter 22: Configuring Security for the Listener Chapter 23: Getting Started with Oracle Recovery Manager (RMAN) Chapter 24: Using RMAN to Back Up Databases Chapter 25: Diagnosing Oracle Database Issues Chapter 26: Recovering from Noncritical Losses Chapter 27: Incomplete Database Recovery Chapter 28: Using Oracle Flashback Database Chapter 29: Recovering From User Errors Chapter 30: Detecting and Recovering from Database Corruption Chapter 31: Tools for Oracle Database 10g Tuning Chapter 32: Monitoring and Managing Storage Chapter 33: Managing Storage with Automatic Storage Management Chapter 34: Computer Telephony Integration Chapter 35: Monitoring and Managing Memory Chapter 36: Automating Administrative Tasks APPENDIX: ABOUT THE CD GLOSSARY: GLOSSARY OF ACRONYMS INDEX