Skip to main content

OCP: Oracle9i DBA Fundamentals II Study Guide: Exam 1Z0-032

OCP: Oracle9i DBA Fundamentals II Study Guide: Exam 1Z0-032

Matthew Weishan, Doug Stuns

ISBN: 978-0-782-15249-4

Feb 2006

515 pages

Select type: E-Book


Product not available for purchase


Here's the book you need to prepare for Exam 1Z0-032: Oracle9i Database: Fundamentals II.
  • 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.


Assessment Test.

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.



ChapterPageDetailsDatePrint Run
Combined Errata

Page 50

Para 3, line 4, 2nd from the bottom, START_WAIT_TIME_LISTENER should be STARTUP_WAIT_TIME_LISTENER

Page 51

Table 2.2, SAVE_CONFIG_ON_STOP, The Oracle Net Manager Prompt should be "Save Configuration on Shutdown" not "Unavailable from Net Manager"

Page 60

Table 2.4, Does spawn still valid in Oracle 9i.

Page 134

1st line,
MAX_SERVERS Parameter should be
also last line in this section
MAX_SERVERS = 5 should be

Page 139

In section "V$SHARED_SERVER_MONITOR Dictionary View", the last line before displaying the results should read:
The query below shows an example of output from the V$SHARED_SERVER_MONITOR new.

Page 141

Last line of the section "Configuring Dedicated Connections..." should read:
(SRVR = DEDICATED) # Request a dedicated connection for DBA

Page 151

Ques. # 13, Option 'D', SERVERS should be changed to SHARED_SERVERS

Page 156

Ques. #20, the correct answer choice is 'D'.

Page 165

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."

Page 237

Section "Exploring the Media Management Library Interface", "or move the library into $ORACLE_HOME/lib directory" change to $ORACLE_HOME/rdbms/lib

Page 303

Section "Relocate and Recover a Tablespace by Using Archive Redo Logs", ORCL should be tst9

Page 308

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."

Page 377

>cp /db01/ORACLE/tst9/data01.dbf /staging/data01.dbf

should be

>cp /db01/ORACLE/tst9/data01.dbf /staging/cold/tst9/data01.dbf

Page 425

Section "Performing a simple export", 4096k should be 4k or 4096 bytes.