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.

My interest in Oracle cenification began in 1996, when I read about the Oracle DBA cenificate offered by the Chauncey Group.I found it difficult to prepare for that cenification exam for two reasons: first, there was an absence of practice questions readily available; second, preparation for the exam involved reviewing six or seven different manuals and Oracle Press books, none of which were particuiarly suited to the task. Judging from the response to the proliferation of titles now available in the OCP Exam Guide Series from Oracle Press, it would seem others have had similar experiences.
　　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.
　　The second unit consists of one chapter containing three full-length practice exams. Each test contains exam-based multiple choice and scenario-based questions that are designed to help you strengthen your test-taking skills for the OCP exams. You will also find answers and in-depth explanations for every question in the practice exams at the end of that chapter, along with a reference back to the exam topic and subtopic objectives from the OCP Candidate Guide.This feature should help you determine your areas requiring.further improvement with pin-point accuracy.
　　There are two appendixes to this text. Appendix A contains materiais designed to help you better understand objea-relational features in Oracle8i. Appendix B contains a glossary of related Oracle database terms that might help you gain a big-picture understanding of the Oracle8i database for your continued professional growth.
　　Finally, a note about updates and errata. Because OCP covers such vast ground in a short time, this has become a living text. If you feel you have encountered difficulties due to errors, you can either check out www.exampilot.com to find the latest errata, or send me an e-mail directly at jcouchman@mindspring.com.
　　Good luck!

(美)Jason S.Couchman：暂无简介

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