This book is divided into two units, the first containing practice exams for each test in the Oracle8i DBA certification track from OracIe. The first unit has five chapters,one for each exam. Each chapter begins with a listing of all the topics tested by theexam, as defined by the Oracle Candidate Guide, a free publication available from Oracle University. Each chapter also contains three practice tests that are approximately the same length of the actual test you will face on exam day. At the end of each chapter,you will find answers with explanations for each of the questions in the exam, along with a reference back to the topic/subtopic listing the question is meant to address.

Jason S. Couchman is a database consultant and the author ofOracle8i Certified Professional DBA Certification Exam Cuide,also from Oracle Press. He is a regular presenter on Oracle and OCP at international Oracle user conferences and meetings. His work has been published by Oracle Magazine Harvard Business School Publishing, and Gannett Newspapers, among others.

My interest in Oracle certification began in 1996, when I read about the Oracle DBA certificate offered by the Chauncey Group.I found it difficult to prepare for that certification exam for two reasons: first, there was an absence of practice questions readily available; second, preparation for the exam invoIved reviewing six or seven different manuals and Oracle Press books, none of which were particularly suited to the task. Judging from the response to this book so far, it would seem others have had similar experiences.
　　This book is divided into two units, the first containing practice exams for each test in the Oracle8i DBA certification track from OracIe. The first unit has five chapters,one for each exam. Each chapter begins with a listing of all the topics tested by theexam, as defined by the Oracle Candidate Guide, a free publication available from Oracle University. Each chapter also contains three practice tests that are approximately the same length of the actual test you will face on exam day. At the end of each chapter,you will find answers with explanations for each of the questions in the exam, along with a reference back to the topic/subtopic listing the question is meant to address.
　　The second unit consists of five chapters, again one for each exam. These chapters contain review materials you may find useful as you wind down your preparation for the OCP exams. In addition, each chapter contains several short-answer fill-in-the-blank questions that will help you review that material for higher retention. In addition, because the OCP exams are starting to feature new question types, these filI-in-the-blanks will help you prepare for this type of question should that format be used on the exam you are taking.
　　There are two appendixes to this text. Appendix A contains an additional 40practice questions covering topics typically tested on Oracle DBA upgrade exams.Since at the time of this book's publication Oracle has not announced an upgrade exam strategy for Oracle8i release 2, 3, or Oracle9i, it is believed that an upgrade strategy may emerge later similar to the strategy Oracle has offered in the past. In this case, you can use these practice questions to prepare for topics covered on upgrade exams, such as using java in the database, the object-relational database computing, and partitioning concepts. Appendix B contains a short glossary of Oracle terms that you may also find useful for preparation purposes.
　　Finally, a note about updates and errata. Because OCP covers such vast ground in a short time, this has become a living text. If you feel you have encountered difficulties due to errors, you can either check out www.exampilot.com to find thelatest errata, or send me an e-mail directly atjcouchman@mindspring.com.
　　Good luck!

(美)Jason S.Couchman：暂无简介

PART 1
OCP Oracle8i DBA Practice Exams
1 OCP Exam 1: Introduction to SQL and PL/SQL
OCP Exam 1 Topic Areas
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Pract1ce Exam 3
2 OCP Exam 2: Database Administration
OCP Exam 2 Topic Areas
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Practice Exam 3
3 OCP Exam 3: Backup and Recovery Workshop
OCP Exam 3 Topic Areas
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Practice Exam 3
4 OCP Exam 4: Performance Tuning Workshop
OCP Exam 4 Topic Areas
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Practice Exam 3
5 OCP Exam 5: Network Administration
OCP Exam 5 Topic Areas
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Practice Exam 3
PART II
OCP Key Terms and Concepts
6 OCP Exam I Terms and Concepts
Overview of Relational Databases, SQL, and PL/SQL
Writing Basic SQL Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Multiple-Column Subqueries
Producing Readable Output from SQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Oracle Data Dictionary
Other Database Objects
Controlling User Access
Declaring Variables
Write Executable Statements
Interacting with the OracIe Server
Writing Control Structures
Working with Composite Datatypes
Writing Explicit Cursors
Advanced Explicit Cursor Concepts
Handling Exceptions
Fill-In-the-Blanks
Fill-In-the-Blank Answers
7 OCP Exam 2 Terms and Concepts
Oracle Architectural Components
Getting Started with Oracle Server
Managing an Oracle Instance
Creating a Database
Data Dictionary Views and Standard Packages
Maintaining the Control FiIe
Maintaining Redo Log Files
Managing Tablespaces and Datafiles
Storage Structures and Relationships
Managing Rollback Segments
Managing Tables
Managing Indexes
Maintaining Data Integrity
Loading Data
Reorganizing Data
Managing Password Security and Resources
Managing Users
Managing Privileges
Managing Roles
Using National Language Support
Fill-in-the-Blanks
Fill-in-the-Blank Answers
8 OCP Exam 3 Terms and Concepts
Backup and Recovery Considerations
Oracle Recovery Structures and Processes
Oracle Backup and Recovery Configuration
Physical Backups Without Oracle Recovery Manager
Oracle Recovery Without Recovery Manager
Incomplete Oracle Recovery with Archiving
Oracle Export and Import Utilities
Additional Oracle Recovery Issues
Oracle Utilities for Troubleshooting
OracIe Recovery Manager Overview
Oracle Recovery Catalog Creation and Maintenance
Backups Using RMAN
Restoration and Recovery Using RMAN
Oracle Standby Database
FiIl-in-the-Blanks
Fill-in-the-Blank Answers
9 OCP Exam 4 Terms and Concepts
Tuning Overview
Oracle Alert and Trace Files
Utilities and Dynamic Performance Views
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning the Redo Log Buffer
Database Configuration and I/O Issues
Using Oracle Blocks Efficiently
Optimize Sort Operations
Rollback Segment Tuning
Monitoring and Detecting Lock Contention
SQL Issues and Tuning Considerations for Different Applications
Managing a Mixed Workload
Tuning with Oracle Expert
Multithreaded Server Tuning Issues
Fill-in-the-Blanks
Fill-in-the-Blank Answers
10 OCP Exam 5 Terms and Concepts
Networking Overview
Basic Net8 Architecture
Basic Net8 Server-Side Configuration
Basic Net8 Client Side Configuration
Centralized Naming Concepts
Usage and Configuration of Oracle Names
Usage and Configuration of the Multithreaded Server
Usage and Configuration of Connection Manager
Troubleshoot the Network Environment
Security in the Network Environment
Fill-in-the-Blanks
Fill-in-the-Blank Answers
A Additional OCP Topical Questions
New Features Questions
Answers to New Features Questions
B Glossary of Common Oracle Terms
Index