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
鄂公網(wǎng)安備 42010302001612號 