OCA/OCP: Oracle9i^TM DBA Fundamentals I Study Guide: Exam 1Z0-031

by Biju Thomas; Bob Bryla

• ISBN13: 9780782140637
• ISBN10: 0782140637
• Edition: CD
• Format: Hardcover
• Copyright: 2002-04-01
• Publisher: Sybex

Summary

Oracle is the leading database on the market, putting Oracle database administrators in high demand. Oracle recently restructured their certification program into three tiers--OCA (Oracle Certified Associate), OCP (...Professional), and OCM (... Master). The first two tiers are exam based, while the third tier (Master) requires the candidate to pass a hands-on exam in a lab environment. Candidates must pass two exams for the OCA certification, and an additional two for the OCP. This book covers the Oracle9i DBA Fundamentals I exam, the second exam required for all three levels.

Author Biography

Biju Thomas, OCP, has over 7 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Bob Bryla, OCP, has worked with Oracle databases for over 10 years. He currently works as an Oracle DBA and Analyst for Lands' End in Dodgeville, Wisconsin.

Table of Contents

Introduction	xvii
Assessment Test	xxviii
Oracle9i New Features for Administrators	1	(28)
Oracle Overview and Architecture	29	(42)
Installing and Managing Oracle	71	(40)
Creating a Database and Data Dictionary	111	(32)
Control and Redo Log Files	143	(42)
Logical and Physical Database Structures	185	(52)
Segments and Storage Structures	237	(30)
Managing Tables, Indexes, and Constraints	267	(82)
Managing Users, Security, and Globalization Support	349	(66)
Glossary	415	(18)
Index	433