This book is divided into two units, the first containing preparatory material for the Oracle9i Introduction to SQL exam part of the Oracle9i DBA certification track.The first unit has eight chapters, each containing several discussions that focus on a particular topic or subtopic objective listed by the Oracle Certified Professional Oracle9i DBA Track Candidate Guide for the Introduction to SQL exam. (For a complete listing of all the topics tested for this exam, check Chapter 1 .) These discussions are followed by a "For Review" section, each listing the three or four most important concepts for you to retain from the discussion. After the review, you'll see two to six exercise questions in exam-based multiple-choice or shortanswer format. Following the questions you will find an answer key for those questions, which should help you master the material even more quickly Thus, with this book you're never more than a few pages away from demonstrating what you've learned about Oracle SQL for the OCP exam.

Jason S. Couchman is a database consultant and the author of Oracle8i Certifiied Professional DBA Certilication Exam Guide also from Oracle Press. He is a regular presenter on Oracle and OCP at international Oracle user conferences and meotings. His work has been published by Oracle Magazine, Harvard Busines 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 involved reviewing six or seven different manuals and Oracle Press books, none of which were particularly suited to the tash.judging from the response to the proliferation of titles now available in the OCP Exam Guide Series from Oracle Press, it would seem others have had similar expenences.
　　This book is divided into two units, the first containing preparatory materiaI for the Oracle9i Introduction to SQL exam part of the Oracle9i DBA certification track.The first unit has eight chapters, each containing several discussions that focus on a particular topic or subtopic objective listed by the Oracle Certified Prolessional Oracle9i DBA Track Candidate Cuide for the Introduction to SQL exam. (For a complete listing of all the topics tested for this exam, check Chapter 1 .) These discussions are followed by a "For Review" section, each listing the three or four most important concepts for you to retain from the discussion. After the review,you'll see two to six exercise questions in exam-based multiple-choice or shortanswer format. Following the questions you will find an answer key for those questions, which should help you master the material even more quickly Thus, with this book you're never more than a few pages away from demonstrating what you've learned about Oracle SQL for the OCP exam.
　　At the end of each chapter, you will find a short summary of what was covered in the chapter, followed by a Two-Minute Drill. The Two--Minute Drill contains another bulleted list of fast facts to review or crib notes for the days leading up to your OCP exam. The chapters conclude with 5 to 20 short-answer and exam-based multiple-choice questions designed to help you further test your understanding of the materials you learned in the chapter.
　　The second unit consists of one chapter containing three full-length practice exams. Each test contains exam-based multiple-choice and scenario-based questions that are designed to help you strengthen your test-taking skills for the OCP exams. You will also find answers and in-depth explanations for the questions in the back of the chapterl along with a reference back to the exam topic and subtopic objectives from the OCP Candidate Cuide. This feature should help you determine with pinpoint accuracy the areas in which you need further improvement.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 wwwexampilot.com to find the latest errata, or send me an email directly at jcouchman@mindspring.com.
　　Good luck!

PART I
Preparing for OCP DBA Exam I: Introduction to SQL
I Overview of Oracie Databases
Overview of Oracle
Theoretical and Physical Aspects of Relational Databases
Oracle's RDBMS and ORDBMS Implementations
Usage and Benefits of PL/SQL
Writing Basic SQL Statements
Capabilities of SQL select Statements
Executing select Statements
Differentiating Between SQL and SQL*Plus Commands
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
2 Limiting, Sorting, and Manipulating Return Data
Restricting and Sorting Row Data
Sorting Return Data with the order by Clause
Limiting Return Data with the where Clause
Using Single-Row Functions
Various Single-Row Functions Explained
Using Functions in select Statements
Date Functions
Conversion Functions
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
3 Advanced Data Selection in Oracle
Displaying Data from MultipIe Tables
The Keys to Table Joins
select Statements That Join Data from More Than One Table
Creating Outer joins
joining a Table to ltself
Group Functions and Their Uses
Identifying and Using Group Functions
Using the group by Clause
Excluding group Data with having
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
4 Subqueries
Using Subqueries
Understanding and Defining Subqueries
Listing and Writing Different Types of Subqueries
Writing Multiple-Column Subqueries
NULL Values and Subqueries
Subqueries in a from Clause
Producing Readable Output with SQL*Plus
Entering Variables
Customizing SQL*Plus Environments.
Producing Readable Output
Creating and Executing Scripts
Saving Customizations
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill--in-the-Blank Answers
Answers to Chapter Questions
5 Creating Oracle Database Objects
Creating the Tables of an Oracle Database
Describing Tables
Creating Tables
Datatypes and Column Definitions
Altering Table Definitions
Dropping, Renaming, and Truncating Tables
Including Constraints
Describing Constraints
Creating and Maintaining Constraints
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
6 Manipulating Oracle Data
Adding New Rows to a Table
Making Changes to Existing Row Data,
Deleting Data from the Oracle Database
Merging Data in Oracle Tables
The Importance of Transaction Control
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the--Blank Answers
Answers to Chapter Questions
7 Creating Other Database Objects in Oracle
Creating Views
Creating Simple Views
Creating Views That Enforce Constraints
Creating Complex Views
Modifying and Removing Views
Other Database Objects
Overview of Other Database Objects
Using Sequences
Using Indexes
Using Public and Private Synonyms..
Chapter Summary
Two-Minute Drill
Fill-in-the--Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
8 UserAccess Control in Oracle
Creating Users
Granting and Revoking Object Privileges
Using Roles to Manage Database Access
Chapter Summary
Two-Minute Drill
Fill-in-the--Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
PART II
OCP Oracle9i DBA Practice Exams
9 OCP Exam I: Introduction to SQL
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers tO Practice Exam 3

无