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

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