OCP Introduction to Oracle9i: SQL Exam Guide

Get Certified with Official Exam Prep Material from Oracle Press

Prepare to pass the Oracle Certified Professional Introduction to Oracle9i: SQL exam--a required exam for OCP DBA certification--using this Oracle Press study guide. Throughout each chapter, youll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what youve learned. Written for novices and experts alike, this book and CD-ROM package is the most comprehensive exam preparation tool available for this Oracle9i Certified Professional exam.

Featuring a logical methodology designed to reinforce learning, this exam guide offers

• 100% complete coverage of all official exam objectives
  
• More than 300 practice questions--including scenario-based and short-answer question formats
  
• Exercises at the end of each chapter that reinforce your Oracle knowledge right away
  
• Tips, examples, and reviews in every chapter to help you remember key concepts
  
• Two-minute drills--quick and concise checklists that summarize each chapters main points
  
• Chapter self-tests--exam-based questions complete with in-depth explanations
  

Required Exam for OCP DBA Certification

Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Contents          

PART I
    Preparing for OCP 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
    6 Manipulating Oracle Data
    7 Creating Other Database Objects in Oracle
    8 User Access Control in Oracle

    PART II
    OCP Oracle9i DBA Practice Exams
    9 OCP Exam 1: Introduction to SQL