OCP Oracle8i SQL&PL/SQL考试学习指南（英文版） (2008 年度畅销榜NO.40164 )

PREFACE\r\nACKNOWLEDGMENTS\r\nINTRODUCTION\r\n\r\nPART I Preparing for OCP DBA Exam I: SQL and PL/SQL\r\n\r\n1 Selecting Data from Oracle\r\n\r\nOverview of SQL and PL/SQL\r\nWriting Basic SQL Statements\r\nRestricting and Sorting Row Data\r\nUsing Single-Row Functions\r\nChapter Summary\r\nTwo--Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n2 Advanced Data Selection in Oracle\r\n\r\nDisplaying Data from Multiple Tables\r\nGroup Functions and Their Uses\r\nUsing Subqueries\r\nMultiple-Column Subqueries\r\nProducing Readable Output with SQL*Plus\r\nChapter Summary\r\nTwo-Minute Drill\r\nFiIl-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n3 Creating Oracle Database Objects\r\n\r\nCreating the Tables of an Oracle Database\r\nIncluding Constraints\r\nThe Oracle Data Dictionary\r\nManipulating Oracle Data\r\nChapter Summary\r\nTwo--Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n4 Creating Other Database Objects in Oracle\r\n\r\nCreating Views\r\nOther Database Objects\r\nUser Access Control\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n5 Introducing PL/SQL\r\n\r\nOverview of PL/SQL\r\nWriting Executable Statements\r\nWriting Control Structures\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blanks\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n6 Database Programming with PL/SQL\r\n\r\nInteracting with the Oracle Database\r\nWorking with Composite Datatypes\r\nExplicit Cursor Handling\r\nUnderstanding Advanced Explicit Cursor Concepts\r\nError Handling\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blanks\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\nPART II\r\nOCP Oracle8i DBA Practice Exams\r\n\r\n7 OCP Exam I: Introduction to SQL and PL/SQL\r\n\r\nPractice Exam 1\r\nPractice Exam 2\r\nPractice Exam 3\r\nAnswers to Practice Exam 1\r\nAnswers to Practice Exam 2\r\nAnswers to Practice Exam 3\r\n\r\nIndex