Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

• PART I Preparing for OCA DBA Exam 1:
• Introduction to SQL
• 1 Overview of Oracle Databases
• 2 Limiting, Sorting, and Manipulating Return Data
• 3 Advanced Data Selection in Oracle
• 4 Subqueries
• 5 Creating Oracle Database Objects
• 5 Creating Oracle Database Objects
• 7 Creating Other Database Objects in Oracle
• 8 User Access Control in Oracle
• PART II OCA Oracle9i SQL Practice Exams
• 9 OCA Exam 1: Introduction to SQL
• PART III Preparing for OCA Database Administration Fundamentals I Exam
• 10 Basics of the Oracle Database Architecture
• 11 Managing the Physical Database Structure
• 12 Managing Tablespaces and Datafiles
• 13 Storage Structures and Undo Data
• 14 Managing Database Objects
• 15 Managing Database Users
• PART IV OCA Oracle9i DBA Fundamentals I Practice Exams
• 16 OCA Database Administration Fundamentals I
• A Globalization Support
• Index