Print this page Share

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

ISBN: 978-0-7821-4064-4
515 pages
May 2002
OCP: Oracle9i DBA Fundamentals II Study Guide: Exam 1Z0-032 (0782140645) cover image


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.

See More

Table of Contents


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.



See More

Author Information

Doug Stuns is an OCP with 12+ years of experience as an Oracle DBA, developer, and trainer. Currently, he is the founder and owner of Stuns Consulting Services. Doug was the coauthor of OCP: Oracle8i Architecture & Administration and Backup/Recovery Study Guide. Matthew Weishan is a senior OCP instructor for Greenbriar & Russel's Oracle-Approved Education Centers. He was a coauthor of OCP: Oracle8i Performance Tuning and Network Administration Study Guide.
See More


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.

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.

See More

Related Titles

Learn more about

Back to Top