This book is divided into two units， the first containing preparatory material for the Oracle8i New Features for Administrators exam in the Oracle8i DBA cenification track from Oracle. The first unit has six chapters， and it begins with a complete listing of all the topics tested by the exam as defined by the Oracle Certified Professional Oracle8i DBA Track Candidate Guide， a free publication available from Oracle University. Each chapter contains several discussions focusing on a panicular topic or subtopic objective listed by the candidate guide. Each discussion is followed with a For Review section， listing the three or four most important concepts for you to retain from the discussion. After the review， the text will give two to. six exercise questions in exam-based multiple-choice or short answer format. Following the questions you will find an answer key for those questions. Thus， you should find that you're never more than a few pages away from demonstrating what you've learned about Oracle8i new features 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 bullet list of fast facts to review as crib notes for the days leading up to your OCP exam. The chapter will conclude with12-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.
FOREWORO ACKNOWLEDGMENT5 INTRODUCTION PART I Oratle8i New Features Exam Guide I Performance and Java Enhancements Java in the Database Optimizer and Query Improvements Summary Management Chapter Summary Two-Minute Drill Fill-in-the-Blanks Chapter Questions Fill-in-the-Blank Answers Answers to Chapter Questions 2 Panitioning and Object Management Index Enhancements Panitioning Improvements Managing Large Objects Chapter Summary Two-Minute Drill Fill-in-the-Blanks Chapter Questions Fill-in-the-Blank Answers Answers to Chapter Questions 3 Database Administration in Oracle8i Oracle Universal Installer: Migration and Upgrade Tablespace Management Database Resource Manager Chapter Summary Two-Minute Drill Fill-in-the-Blanks Chapter Questions Fill-in-the-Blank Answers Answers to Chapter Questions 4 Manageability Enhancements Manageability Enhancements Chapter Summary Two Minute Drill Fili-in-the-Blanks Chapter Questions Fill-in-the-Blank Answers Answers to Chapter Questions 5 Availability and Recoverability Enhancemenn Availability and Recoverability Enhancements Chapter Summary Two Minute Drill Fill-in-the-Blanks Chapter Questions Fill-in-the-Blank Answers Answers to Chapter Questions 6 Other Enhancements in Oracle8i Features of Net8 SQL*Plus and PL/SQL Enhancements Database Security Chapter Summary Two-Minute Drill Fill-in-the-Biank Questions Chapter Questions Fill-in-the-Blank Answers Answers to Chapter Questions PART II Oratle8i Certified Professional New Features Praetite Exams 7 OCP Oracle8i Upgrade Exam: New Features for Administrators Practice Exam 1 Practice Exam 2 Practice Exam 3 Answers to Practice Exam 1 Answers to Practice Exam 2 Answers to Practice Exam 3 PART III Appendixes A Object Relational Database Features in Oracle8i Defining Object Types Defining Object Methods Creating Object Tables Implementing Collections Using REF-Column Referential Integrity Analyzing Dangling References Migrating Relational Databases Using Object Views Using instead of Triggers B Glossary of Common Oracle Terms Oracle Networking Index
鄂公網(wǎng)安備 42010302001612號(hào) 