After an introductory overview of the OCP testing process, the architectural concepts of Oracle are presented, including various components of the Oracle Shared Global Area and the Data Dictionary. A basic understanding of Oracle is a good prerequisite for this review-oriented title. After the first chapters, the book moves into the SQL language, including discussions of Database Definition Language (DDL), Data Manipulation Language (DML), and a critical examination of ALTER and DROP--two commands that figure prominently into any database administrator's daily duties.
The book then details PL/SQL--the Oracle dialect of SQL that adds programming structure and power to the query language. User management, utilities, and database design concepts are covered in succeeding chapters. A final chapter on administration covers more advanced profile and resource issues.
Each chapter includes an exam prep quiz, and icons mark tips and common trick questions. Oracle DBA Test 1 and Test 2 Exam Cram packs the key concepts of an enormous amount of information into a short, clearly organized package. With some foundational knowledge in Oracle as a starter, this title will get you ready for your first two certification exams. --Stephen Plain