OCP: Oracle9i DBA Fundamentals II Study Guide: Exam 1Z0-032
- In-depth coverage of official exam objectives
- Practical information on implementing and managing Oracle9i databases
- Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
- Identifying solutions included with Oracle9i for managing complex networks
- Using Oracle Net Services and client server connections
- Establishing web client connections through Oracle networking products
- Troubleshooting database connections
- Using and configuring the Oracle Shared Server
- Backing up, restoring, and recovering databases
- Configuring the database archiving mode
- Using Recovery Manager (RMAN)
- Loading data into, and transporting data between databases
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Chapter1 Introduction to Network Administration.
Chapter2 Configuring Oracle Net on the Server.
Chapter3 Configuring Oracle Net for the Client.
Chapter4 Configuring the Shared Server Option.
Chapter5 Backup and Recovery Overview.
Chapter6 Instance and Media Recovery Structures.
Chapter7 Configuring the Database Archiving Mode.
Chapter8 Oracle Recovery Manager Overview and Configuration.
Chapter9 User-Managed and RMAN-Based Backups.
Chapter10 User-Managed Complete Recovery and RMAN Complete Recovery.
Chapter11 User-Managed and RMAN-Based Incomplete Recovery.
Chapter12 RMAN Maintenance.
Chapter13 Recovery Catalog Creation and Maintenance.
Chapter14 Transporting Data between Databases.
Chapter15 Using SQL*Loader to Load Data.
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
Para 3, line 4, 2nd from the bottom, START_WAIT_TIME_LISTENER should be STARTUP_WAIT_TIME_LISTENER
Table 2.2, SAVE_CONFIG_ON_STOP, The Oracle Net Manager Prompt should be "Save Configuration on Shutdown" not "Unavailable from Net Manager"
Table 2.4, Does spawn still valid in Oracle 9i.
In section "V$SHARED_SERVER_MONITOR Dictionary View", the last line before displaying the results should read:
Last line of the section "Configuring Dedicated Connections..." should read:
Ques. # 13, Option 'D', SERVERS should be changed to SHARED_SERVERS
Ques. #20, the correct answer choice is 'D'.
the last line of the first paragraph reads:"The Data Manipulation Language (DML) can be seen in the v$logmnr_contents table after the PL/SQL procedures have been executed." Should read "The Data Manipulation Language (DML) can be seen in the v$logmnr_contents view after the PL/SQL procedures have been executed."
Section "Exploring the Media Management Library Interface", "or move the library into $ORACLE_HOME/lib directory" change to $ORACLE_HOME/rdbms/lib
Section "Relocate and Recover a Tablespace by Using Archive Redo Logs", ORCL should be tst9
Last line of subject "Describe Read-Only Tablespace Recovery". "...doing so eliminates the need to restore the tablespace." should be "...doing so eliminates the need to recover the tablespace."
>cp /db01/ORACLE/tst9/data01.dbf /staging/data01.dbf
>cp /db01/ORACLE/tst9/data01.dbf /staging/cold/tst9/data01.dbf
Section "Performing a simple export", 4096k should be 4k or 4096 bytes.