Oracle9i Database: Fundamentals II ™

Exam Number:	1Z0-032
Associated Certifications:	Oracle9i DBA OCP
Exam Price:	US$125
Exam Registration:	Register

Duration:

120 minutes

Number of Questions:

Passing Score:

73%

Passing score subject to change. View Details

Recommended Training and Preparation

The exam is based on Oracle9i Release 2

Oracle9i Database: Fundamentals II

Oracle9i DBA Fundamentals II Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.

Additional Information & Resources

Practice Exams

Oracle authorized practice exam from Self Test Software. 1Z0-032 Oracle9i: DBA Fundamentals II
Oracle authorized practice exam from Transcender: Cert-1Z0-032 : DBCert: 9i Database: Fundamentals II

Oracle9i DBA Certification Exam Candidate Guide
Exam Retake Policy
Sample Questions

Exam Topics

Networking Overview
[ ]	Explain solutions included with Oracle9i for managing complex networks
[ ]	Describe Oracle networking add-on solutions

Basic Oracle Net Architecture
[ ]	Explain the key components of the Oracle Net layered architecture
[ ]	Explain Oracle Net Services role in client server connections
[ ]	Describe how web client connections are established through Oracle networking products

Basic Net Server-Side Configuration
[ ]	Identify how the listener responds to incoming connections
[ ]	Configure the listener using Oracle Net Manager
[ ]	Control the listener using the Listener Control Utility (lsnrctl)
[ ]	Describe Dynamic Service Registration
[ ]	Configure the listener for IIOP and HTTP connections

Basic Oracle Net Services Client-Side Configuration
[ ]	Describe the difference between host naming and local service name resolution
[ ]	Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
[ ]	Perform simple connection troubleshooting

Usage and Configuration of the Oracle Shared Server
[ ]	Identify the components of the Oracle Shared Server
[ ]	Describe the Oracle Shared Server architecture
[ ]	Configure the Oracle Shared Server
[ ]	Identify and explain usefulness of related dictionary views

Backup and Recovery Overview
[ ]	Describe the basics of database backup, restore and recovery
[ ]	List the types of failure that may occur in an Oracle environment
[ ]	Define a backup and recovery strategy

Instance and Media Recovery Structures
[ ]	Describe the Oracle processes, memory structures, and files relating to recovery
[ ]	Identify the importance of checkpoints, redo log files, and archived log files
[ ]	Describe ways to tune instance recovery

Configuring the Database Archiving Mode
[ ]	Describe the differences between Archivelog and Noarchivelog modes
[ ]	Configure a database for Archivelog mode
[ ]	Enable automatic archiving
[ ]	Perform manual archiving of logs
[ ]	Configure multiple archive processes
[ ]	Configure multiple destinations, including remote destinations

Oracle Recovery Manager Overview and Configuration
[ ]	Identify the features and components of RMAN
[ ]	Describe the RMAN repository and control file usage
[ ]	Describe channel allocation
[ ]	Describe the Media Management Library interface
[ ]	Connect to RMAN without the recovery catalog
[ ]	Configure the RMAN environment

User-Managed Backups
[ ]	Describe user-managed backup and recovery operations
[ ]	Discuss backup issues associated with read tablespaces
[ ]	Perform closed database backups
[ ]	Perform open database backups
[ ]	Back up the control file
[ ]	Perform cleanup after a failed online backup
[ ]	Use the DBVERIFY utility to detect corruption

RMAN Backups
[ ]	Identify types of RMAN specific backups
[ ]	Use the RMAN BACKUP command to create sets
[ ]	Back up the control file
[ ]	Back up the archived redo log files
[ ]	Use the RMAN COPY command to create image copies

User-Managed Complete Recovery
[ ]	Describe media recovery
[ ]	Perform recovery in Noarchivelog mode
[ ]	Perform complete recovery in Archivelog mode
[ ]	Restore datafiles to different locations
[ ]	Relocate and recover a tablespace by using archived redo log files
[ ]	Describe read-only tablespace recovery

RMAN Complete Recovery
[ ]	Describe the use of RMAN for restoration and recovery
[ ]	Perform recovery in Noarchivelog mode
[ ]	Perform complete recovery in Archivelog mode
[ ]	Restore data files to different locations
[ ]	Reloate and recover a tablespace by using archived redo log files

User-Managed Incomplete Recovery
[ ]	Describe the steps of incomplete recovery
[ ]	Perform an incomplete database recovery
[ ]	Identify the loss of current online redo log files

RMAN Incomplete Recovery
[ ]	Perform an incomplete database recovery using UNTIL TIME
[ ]	Perform an incomplete database recovery using UNTIL SEQUENCE

RMAN Maintenance
[ ]	Perform cross checking of backups and copies
[ ]	Update the repository when backups have been deleted
[ ]	Change the availability status of backups and copies
[ ]	Make a backup or copy exempt from the retention policy
[ ]	Catalog backups made with operating system commands

Recovery Catalog Creation and Maintenance
[ ]	Describe the contents of the recovery catalog
[ ]	Create the recovery catalog
[ ]	Maintain the recovery catalog by using RMAN commands
[ ]	Use RMAN to register, resynchronize, and reset a database
[ ]	Query the recovery catalog to generate reports and lists
[ ]	Create, store, and run scripts
[ ]	Describe methods for backing up and recovering the recovery catalog

Transporting Data Between Databases
[ ]	Describe the uses of the Export and Import utilities
[ ]	Describe Export and Import concepts and structures
[ ]	Perform simple Export and Import operations
[ ]	List guidelines for using Export and Import

Loading Data into a Database
[ ]	Demonstrate usage of direct- load insert operations
[ ]	Describe the usage of SQL*Loader
[ ]	Perform basic SQL*Loader operations
[ ]	List guidelines for using SQL*Loader and direct-load insert

Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.