Synopses & Reviews
Full Coverage of Exams 1Z0-007 & 1Z0-031
Prepare for Certification with Authoritative Exam Prep Material from Oracle Press
Prepare for the Oracle Certified Associate DBA exams by using this comprehensive Oracle Press study guide. Throughout each chapter, you'll find in-depth details on the material covered in these challenging exams, followed by practice questions and chapter summaries to highlight what you've learned. From the exclusive publisher of Oracle Press books, this package is the most comprehensive preparation tool available for the OCA exams.
- 100% complete coverage of all official exam objectives
- Exercises at the end of all discussions 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 chapter's main points
- Chapter self-tests--exam-based questions complete with in-depth explanations
- More than 600 practice questions--including scenario-based questions
Synopsis
Using the successful all-in-one approach for the OCA, this title combines the existing books covering the exams into one complete book/CD offering. The book content was developed using Oracle's certification blueprints, ensuring 100 percent coverage of official exam objectives.
Synopsis
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.
Table of Contents
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
6: Manipulating Oracle Data
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
Appendix A: Globalization Support