DBA certification exam guide

Featuring a logical methodology designed to reinforce your learning experience, this guide offers the following study aids:

• Tips, examples, and exercises to help you remember key concepts
  
• Two-minute drills - Quick and concise checklists that summarize a chapter's main points; perfect for last minute review
  
• Chapter self-tests - Chapter-specific questions similar to those found on the exam with detailed answers to each question
  
• The latest information on the new scenario-based exam questions
  
• Comprehensive coverage of Oracle-designated exam objectives, including SQL and PL/SQL, advanced performance tuning, database administration, backup and recovery, Oracle8, and much more
  
• Interactive Exam on CD allows you to hotlink directly to the relevant part of the text - the entire book is in electronic format

Make a smart career move and begin enjoying all the rewards of OCP certification. This officially endorsed study guide offers a complete preparation system geared to help you pass your exams with flying colors!

Table of contents :

Preface ..... xxi

Acknowledgements ..... xxv

Introduction ..... xxvi

UNIT I: Preparing for OCP DBA Exam 1: SQL and PL/SQL

Chapter 1: Selecting Data from Oracle ..... 3

Chapter 2: Advanced Data Selection in Oracle ..... 51

Chapter 3: Creating the Oracle Database ..... 99

Chapter 4: Creating Other Database Objects in Oracle ..... 153

Chapter 5: Introducing PL/SQL ..... 209

UNIT II: Preparing for OCP DBA Exam 2: Database Administration

Chapter 6: Basics of the Oracle Database Architecture ..... 261

Chapter 7: Managing the Physical Database Structure ..... 317

Chapter 8: Managing Database Objects ..... 379

Chapter 9: Managing Database Usage ..... 439

Chapter 10: Using SQL*Loader ..... 495

UNIT III: Preparing for OCP DBA Exam 3: Backup and Recovery Workshop

Chapter 11: Overview of Backup and Recovery ..... 525

Chapter 12: Logical Backup and Recovery ..... 575

Chapter 13: Physical Recovery Without Archiving ..... 627

Chapter 14: Backup and Recovery Options with Archiving ..... 675

Chapter 15: Advanced Topics of Oracle Backup and Recovery ..... 723

UNIT IV: Preparing for OCP DBA Exam 4: Performance Tuning Workshop

Chapter 16: Introducing Database Tuning ..... 773

Chapter 17: Tuning Database Applications ..... 811

Chapter 18: Tuning Memory Utilization ..... 851

Chapter 19: Tuning Disk Utilization ..... 903

Chapter 20: Tuning Other Areas of the Oracle Database ..... 955

UNIT V: Preparing for OCP DBA Exam 5: Oracle8 Features for Administrators

Chapter 21: Oracle8: Partitioning Tables and Indexes ..... 995

Chapter 22: Oracle8: New Features and Object Relational Design ..... 1045

Chapter 23: Oracle8: Parallel DML, LOBs, and Advanced Queing ..... 1097

Chapter 24: Oracle8: Using Recovery Manager ..... 1147

Chapter 25: Oracle8: Networking, Security, and Migration ..... 1191

Appendix ..... 1231

Index ..... 1237