oracle认证 考试 英文,OCP Oracle9i SQL 考试指南（英文版）

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