PREFACE
ACKNOWLEDGMENTS
INTRODUCTION
PART I Preparing for OCP DBA Exam I: SQL and PL/SQL
1 Selecting Data from Oracle
Overview of SQL and PL/SQL
Writing Basic SQL Statements
Restricting and Sorting Row Data
Using Single-Row Functions
Chapter Summary
Two--Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
2 Advanced Data Selection in Oracle
Displaying Data from Multiple Tables
Group Functions and Their Uses
Using Subqueries
Multiple-Column Subqueries
Producing Readable Output with SQL*Plus
Chapter Summary
Two-Minute Drill
FiIl-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
3 Creating Oracle Database Objects
Creating the Tables of an Oracle Database
Including Constraints
The Oracle Data Dictionary
Manipulating Oracle Data
Chapter Summary
Two--Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
4 Creating Other Database Objects in Oracle
Creating Views
Other Database Objects
User Access Control
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
5 Introducing PL/SQL
Overview of PL/SQL
Writing Executable Statements
Writing Control Structures
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
6 Database Programming with PL/SQL
Interacting with the Oracle Database
Working with Composite Datatypes
Explicit Cursor Handling
Understanding Advanced Explicit Cursor Concepts
Error Handling
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
PART II
OCP Oracle8i DBA Practice Exams
7 OCP Exam I: Introduction to SQL and PL/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
Index
鄂公網安備 42010302001612號 