OCP: Oracle 9i^TM Certification Kit (Covers All Four Required Exams: 1Z0-007, 1Z0-031, 1Z0-032, 1Z0-033)

by Chip Dawes; Biju Thomas; Doug Stuns; Matthew Weishan; Joseph C. Johnson

• ISBN13: 9780782140668
• ISBN10: 0782140661
• Format: Hardcover
• Copyright: 2002-01-01
• Publisher: Sybex

Summary

The Oracle Certification Solution from Sybex The new Oracle9i certification program offers three certification tiers that are built to fit the needs of IT professionals as well as organizations looking to hire them. As you gain more skills and knowledge through the combined efforts of hands-on experience and training, you can gain more credibility with each new tier of certification you obtain. Sybex has a comprehensive line of Study Guides that will get you in position to approach the exams with confidence. The Best Oracle9i Book/CD Package on the Market! Get ready for the Oracle9i OCP exams with the most comprehensive and challenging sample tests anywhere! Chapter-by-chapter exam coverage of all the review questions from the books. Each CD includes two bonus exams. Search through each Study Guide for the information you need. Access each Oracle9i Study Guide, complete with figures and tables, in electronic format. Use the Electronic Flashcards to job your memory and prep last-minutes for the exam! Reinforce your understanding of key concepts with challenging flashcard-style questions. (Now available for your Palm handheld as well!) Contains the following: OCA/OCP: Introduction to Oracle9i SQL Study Guide (1Z0-007) OCA/OCP: Oracle9i DBA Fundamentals I Study Guide (1Z0-031) OCP: Oracle9i DBA Fundamentals II Study Guide (1Z0-032) OCP: Oracle9i Performance Tuning Study Guide (1Z0-033) Four CDs with Leading-Edge Software: Testing Engine with Hundreds of Challenging Questions Eight Bonus Exams Electronic Flashcards for PCs and Palm Handhelds All Four Books in Digital Format

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	(36)
Introduction	xxi
Assessment Test	xxxiii
Introduction to Network Administration	1	(34)
Configuring Oracle Net on the Server	35	(54)
Configuring Oracle Net for the Client	89	(32)
Configuring the Shared Server Option	121	(36)
Backup and Recovery Overview	157	(20)
Instance and Media Recovery Structures	177	(24)
Configuring the Database Archiving Mode	201	(26)
Oracle Recovery Manager Overview and Configuration	227	(24)
User-Managed and RMAN-Based Backups	251	(34)
User-Managed Complete Recovery and RMAN Complete Recovery	285	(50)
User-Managed and RMAN-Based Incomplete Recovery	335	(30)
RMAN Maintenance	365	(22)
Recovery Catalog Creation and Maintenance	387	(30)
Transporting Data between Databases	417	(26)
Using SQL*Loader to Load Data	443	(26)
Glossary	469	(24)
Index	493