We have included two full-length practice exams in this chapter. Each practice exam consists of 64 questions that cover the areas Of Oracle NetWorking and Oracle Backup and Recovery as part of the OCP DBA II Fundamentals exam. If you have studied this guide and gone over the questions and answers at the end of each chapter, you are ready to take these exams.
You should give yourself 90 minutes for each exam. Time yourself, and take the entire exam in one sitting. Do not peek at the answers or look at the preceding chapters. Remember, only a practice test can telI how well you are utiIizing your time in the exam. This wilI help you to gauge your readiness for taking the OCP exam. We Suggest that after taking the first exam, you review your answers carefully and study the chapters relating to the questions that were answered incorrectly Take the second exam after sufficient preparation. If you answer more than 75 percent of the questions correctly, you are ready to take the actuaI exam.
We have included some tips and suggestions on test taking strategies in the Introduction of this guide. Read it carefully before taking the exam.
Rama Velpuri
Rama Velpuri is the founder and CEO of ORAMASTERS Inc.ORAMASTERS specialize5 in providing online support services for Oracle users worldwide. Before founding ORAMASTERS, Mr. Velpuri worked with Oracle Corporation for more than ten years. At Oracle, he was an Executive Director of the Oracle AppIications Development Center He has built two offshore development centers for Oracle, one in Bangalore, India India Product Engineering Center), and the other in Hyderabad,India(Oracle Application Development Center). Before that,he was a Senior Manager of the Mission Critical Support Center. Mr. Velpuri has presented numerous technical papers at various International Oracle Conferences and Oracle user conferences on disaster recovery and he has trained Oracle support personnel in 22 different countries in problem-solving techniques. You can reach him via e-mail at rvelpuri@oramasters.com.
Rama's Oracle Press Books:
Oracle8i Backup & Recovery Handbook (ISBN 0-07-21271 7-1, 2001 )
Oracle8 Backup & Recovery Handbook (ISBN 0-07-882389-7, 1998)
Oracle8 Troubleshooting (ISBN 0-07-882580-6, 1999)
Oracle NT Handbook (ISBN 0-07-211917-9, 1998)
Oracle Troubleshooting (ISBN 0-07-882388-9, 1997)
Oracle Backup & Recovery Handbook 73 Edition (ISBN 0--07-882323-4,1997)
Oracle Backup & Recovery Handbook (ISBN 0-07-882106-1, 1995)
About the Oracle Certification Exams
The expertise of Oracle database administrators (DBAs) is integral to the success of today's increasingly complex system environments. The best DBAs operate primarily behind the scenes, looking for ways to fine-tune day-to-day Performance to prevent unscheduled crises and hours of expensive downtime. They know they stand between optimal performance and a crisis that could bring a company to a standstill. The Oracle Certified Database Administrator Track provides DBAs with tangible evidence of their skills with the Oracle database.
The Oracle Certified Professional(OCP) Program was developed by Oracle to recognize technical professionals who can demonstrate the depth of knowledge and hands-on skills required to maximize Oracle's core products according to a rigorous standard established by Oracle. By earning profesional certification,you can translate the impressive knowledge and skill you have worked so hard to accumulate into a tangible credential that can lead to greater job security or more challenging, better-paying opportunities.
Oracle Certified Professionals are eligible to receive use of the Oracle Certified Professional logo and a certificate for framing.
Requirements for Certification
To become an Oracle Certified Database Administrator for the Oracle9i track,you must pass four tests. These exams cover knowledge of the essential aspects of the SQL language, Oracle administration, backup and recovery, and Performance tuning of systems. The certification process requires that you pass the following four exams:
Exam 1: Introduction to Oracle9i: SQL (1Z0-007)
Exam 2: Oracle9i Database: Fundamentals 1 (1Z0-031 )
Exam 3: Oracle9i Database: Fundamentals II (1Z0-032)
Exam 4: Oracle9i Database: Performance Tuning (1Z0-033)
If you fail a test, you must wait at least 30 days before you retake that exam. You may attempt a particular test up to 3 times in a 12-month period.
Recertification
Oracle announces the requirements for upgrading your certification based on the release of new products and upgrades. Oracle will give six months' notice announcing when an exam version is expiring.
Exam Format
The computer-based exams are multiple-choice tests, consisting of 50--65 questions that must be completed in 90--120 minutes.
(美)Rama Velpuri：暂无简介
PART I
Oracle Networking
1 Networking Overview
NetWorking Challenges in the Business Environment
Network Configurations
Oracle's Solution to NetWorking lssues
Chapter Questions
Answers to Chapter Questions
2 Basic Oracle Net Architecture
Open System Interconnection Architecture
Oracle Net Layered Architecture
Oracle Net Services
Web Client Connections
Chapter Questions
Answers to Chapter Questions
3 Basic Net Server-Side Configuration
How the Listener Responds to Incoming Connections
Components of the Listener
Configuring the Listener Using the Oracle Net Manager
Controlling the Listener Using the Listener Control Utility (Isnrctl)
Dynamic Service Registration
Configuring the Listener for IIOP
Chapter Questions
Answers to Chapter Questions
4 Basic Oracle Net Services Client-Side Configuration
Naming Methods
Configuring the Host Naming Method
Configuring the Local Naming Method
Configuring Net Service Names
Performing Simple Connection Troubleshooting
Chapter Questions
Chapter Answers
5 Usage and Configuration of the Oracle Shared Server
Identifying the Components of the Oracle Shared Server
Oracle Shared Server Architecture
Configuring the Orac1e Shared Server
Shared Server Related Dictionary Views
Chapter Questions
Chapter Answers
PART II
Backup and Recovery
6 Backup and Recovery Overview
Classification of Failures
Basics of Database Backup, Restoration, and Recovery
Backup and Recovery Strategies
Disaster Recovery Plan
Oracle'S High-Availability Features
Chapter Questions
Answers to Chapter Questions
7 Instance and Media Recovery Structures
Oracle Memory Structures
Oracle Background Processes
Oracle Database Files
Importance of Checkpoints During Instance Recovery
Chapter Questions
Answers to Chapter Questions
8 Configuring the Database Archive Mode
Differences Between ARCHIVELOG and NOARCHIVELOG Mode
Configuring a Database for ARCHIVELOG Mode
Configuring Multiple Archive Processes
Configuring Multiple Destinations, Including Remote Destinations
Useful V$VIEWS
Chapter Questions
Answers to Chapter Questions
9 Oracle Recovery Manager Overview and Connguration
Features of RMAN
Components of RMAN
RMAN Repository
RMAN Channel Allocation
Media Management Library Interface
Connecting to RMAN Without the Recovery Catalog
Configuring the RMAN Environment
Chapter Questions
Answers to Chapter Questions
l0 User-Managed Backups
User-Managed Backup and Recovery
Closed Database Backups
Open Database Backups
Backups of Read-Only Tablespaces
Backup of the Control File
Backups of Archived Redo Logs
Cleanup Operations after Failed Online Backups
LOGGING and NOLOGGING Options
dbverify Utility
Chapter Questions
Answers to Chapter Questions
ll RMAN Backups
RMAN Backup Concepts
RMAN Image Copies
RMAN Backup Sets
Tags for Backup Sets and Image Copies
Backing Up the ControI File
Backing Up the Archive Redo Log files
Important V$VIEWS
Chapter Questions
Chapter Answers
l2 User-Managed Complete Recovery
Media Recovery
Performing User-Managed Complete Recovery
Performing Recovery in NOARCHIVELOG Mode
Performing Complete Recovery in ARCHlVELOG Mode
Restoring Data Files to Different Locations
Relocating and Recovering a Tablespace Using Archived
Loss of an Online Inactive Redo Log Group and Recovery
Recovery of Read-Only Tablespaces
Chapter Questions
Chapter Answers
l3 RMAN Complete Recovery
Server Managed Media Recovery Using RMAN
Performing Recovery in NOARCHIVELOG Mode
Performing Complete Recovery in ARCHIVELOG Mode
Restore Data Files to Different Locations Using RMAN
Relocate and Recover a Tablespace Using the Archived Redo Log Files
Block Media Recovery (BMR)
Chapter Questions
Chapter Answers
14 User Managed Incomplete Recovery
Incomplete Recovery
Identifying Loss of a Current Online Redo Log File
Media Recovery in Parallel
ImportantV$VIEWS
Chapter Questions
Chapter Answers
15 RMAN Incomplete Recovery
Incomplete Recovery Using RMAN
Perform an Incomplete Database Recovery Using UNTIL TIME
Perform Incomplete Database Recovery Using UNTIL SEQUENCE
Restore Optimization
Chapter Questions
Chapter Answers
16 RMAN Maintenance
RMAN Crosscheck
Performing a Crosscheck of Backup Sets and Image Copies
Updating the Repository When Backups Have Been Deleted
Changing the Availability Status of Backup Sets and Image Copies
Making a Backup Set or an Image Copy Exempt from the
Cataloging Backups Made with the Operating System Commands
Chapter Questions
Chapter Answers
17 Recovery Catalog Creation and Maintenance
Contents of the Recovery Catalog
Recovery Catalog Creation
Use RMAN to Register, Resynchronize, and Reset a Database
Maintain the Recovery Catalog by Using RMAN Commands
Query the Recovery Catalog to Generate Reports and Lists
Create, Store, and Run Scripts
Methods Of Backing Up and Recovering the Recovery Catalog
Important Recovery Catalog Views
Chapter Questions
Chapter Answers
18 Transporting Data Between Databases
Oracle Logical Backups
Export Concepts and Structures
Import Concepts and Structures
A List of Export and Import ferameters
Methods to Invoke Export and Import
Perform Export and Import Operations
List Guidelines for Using Export and Import
Chapter Questions
Chapter Answers
19 Loading Data into a Database
Direct-Path Insert Operations
SQL*Loader Usage
Loading Methods in SQL*Loader
SQL*Loader Files
Performing Basic SQL*Loader Operations
Guidelines for Using SQL*Loader and Direct-Load Insert
Chapter Questions
Chapter Answers
PART III
TestYourseIf: Oracle9i DBA Practice Exams
20 Practice Exams for OCP DBA II Fundamentals
Full--Length Examination I
Full-Length Examination II
Answers to Full-Length Examination I
Answers to Full-Length Examination II
Index
