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

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

Auteur

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.

Résumé
The Most Authoritative OCA/OCP Exam Guide AvailablePrepare 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 databaseUse SQL, SQL*Plus, iSQL*Plus, and PL/SQLCreate and manage database user accountsConfigure Oracle NetworkingManage shared serversMonitor, tune, and troubleshoot a databaseHandle database backup, restore, and recoveryUse Oracle Recovery Manager and Oracle FlashbackConfigure and manage securityUse Automatic Storage Management and Resource ManagerAutomate administrative tasksIncluded on the CD-ROMElectronic Practice Test engine with two full practice examsComplete electronic book

Contenu

Part I: Oracle Database 10g Administrative I ExamChapter 1: Basic Oracle ConceptsChapter 2: Installing Oracle Database 10gChapter 3: Creating an Oracle DatabaseChapter 4: Interfacing with the Oracle DatabaseChapter 5: Managing Oracle ProcessesChapter 6: Managing Oracle Storage StructuresChapter 7: Administering Database UsersChapter 8: Managing Database ObjectsChapter 9: Manipulating Database DataChapter 10: Programming Oracle with PL/SQLChapter 11: Securing the Oracle DatabaseChapter 12: Configuring Oracle NetworkingChapter 13: Managing Shared ServersChapter 14: Managing Database PerformanceChapter 15: Monitoring OracleChapter 16: Managing UndoChapter 17: Dealing with LockingChapter 18: Configuring the Database for Backup and RecoveryChapter 19: Backing Up an Oracle DatabaseChapter 20: Recovering Oracle DatabasesChapter 21: Managing Globalization in Oracle DatabasesPart II: Oracle Database 10g Administrative II ExamChapter 22: Configuring Security for the ListenerChapter 23: Getting Started with Oracle Recovery Manager (RMAN)Chapter 24: Using RMAN to Back Up DatabasesChapter 25: Diagnosing Oracle Database IssuesChapter 26: Recovering from Noncritical LossesChapter 27: Incomplete Database RecoveryChapter 28: Using Oracle Flashback DatabaseChapter 29: Recovering From User ErrorsChapter 30: Detecting and Recovering from Database CorruptionChapter 31: Tools for Oracle Database 10g TuningChapter 32: Monitoring and Managing StorageChapter 33: Managing Storage with Automatic Storage ManagementChapter 34: Computer Telephony IntegrationChapter 35: Monitoring and Managing MemoryChapter 36: Automating Administrative TasksAPPENDIX: ABOUT THE CDGLOSSARY: GLOSSARY OF ACRONYMSINDEX