Oracle Database 10g DBA New Features for Oracle8i OCPs

Exam Number:	1Z0-045
Associated Certifications:	Oracle8i OCPs to Oracle Database 10g
Exam Price:	$125 USD
Exam Registration:	Register

Duration:

2 hours

Number of Questions:

Passing Score:

73%

Passing score subject to change. View Details

Recommended Training and Preparation

The exam has been validated against Oracle Database 10g and Oracle Database 10g R2 and is compatible with both. Classroom training, practice and experience on either release is suitable preparation.

Oracle Database 10g: New Features for Oracle8i DBAs

Additional Information & Resources

Practice Exams

Oracle authorized practice exam from Self Test Software. 1Z0-045 Oracle Database 10g DBA New Features for Oracle8i OCPs
Oracle authorized practice exam from Transcender: DBCert: Oracle Database 10g DBA New Features for Oracle8i OCPs

Oracle 10g DBA Candidate Guide
Exam Retake Policy

Exam Topics

Oracle Server Security
[ ]	Explain the privileged connection options

General High Availability Technology
[ ]	Explain the Oracle Flashback feature
[ ]	Describe Resumable Space Allocation

Oracle LogMiner Enhancements
[ ]	Explain LogMiner new features: DDL statement support, dictionary staleness detections, ability to use an online dictionary, ability to skip log corruptions

Backup and Recovery
[ ]	Describe new RMAN manageability features: backup enhancements, restore/recovery enhancements
[ ]	Describe new RMAN reliability features: Block media recovery (BMR), Trial Recovery
[ ]	Block media recovery (BMR), Trial Recovery

Database Resource Manager Enhancements
[ ]	Automatically limit resource consumption other than CPU and DOP

Online Operations
[ ]	Describe online table redefinitions
[ ]	Describe the use of the Server Parameter File (SPFILE)

Segment Management (Part II)
[ ]	Explain and use the new Automatic Segment-Space Management functionality

Performance Improvements
[ ]	Describe the cursor sharing enhancements

File Management
[ ]	Create and manage OMF files

Tablespace Management
[ ]	Create and maintain UNDO tablespaces

Memory Management
[ ]	Set parameters to enable automatic and dynamic sizing of SQL working areas

Globalization Support
[ ]	Describe the Unicode enhancements
[ ]	Use the Character Set Scanner

Installation
[ ]	Describe installation new features support
[ ]	Describe installation performance enhancements

Server Configuration
[ ]	Simplify instance configuration using a subset of initialization parameters
[ ]	Use policy-based database configuration framework
[ ]	View database usage statistics through EM

Load and Unload Data
[ ]	Transport tablespaces across different platforms
[ ]	Explain Data Pump architecture
[ ]	Monitor a Data Pump job
[ ]	Use Data Pump export and import
[ ]	Create external tables for data population
[ ]	Define your external table properties

Automatic Management
[ ]	Use Automatic Database Diagnostic Monitor
[ ]	Use Automatic Shared Memory Management
[ ]	Use Automatic Optimizer Statistics Collection
[ ]	Use Automatic Undo Retention Tuning

Manageability Infrastructure
[ ]	Monitor and maintain the AWR
[ ]	Use the Active Session History (ASH)
[ ]	Monitor and manage server-generated alerts
[ ]	Explain the automated tasks feature
[ ]	Describe the advisory framework

Application Tuning
[ ]	Use the new optimizer statistics
[ ]	Use the SQL Tuning Advisor
[ ]	Use the SQLAccess Advisor
[ ]	Use the performance pages of Database Control

Support for Analytical Applications
[ ]	Write MERGE statements with the new conditions and extensions
[ ]	Use partitioned outer join syntax for densification
[ ]	Use interrow calculations to enhance SQL for analytical capabilities

System Resource Management
[ ]	Automatically switch a session back to the original consumer group at the end of the top call
[ ]	Set idle time-outs for consumer groups
[ ]	Create mappings for the automatic assignment of sessions to consumer groups

Automating Tasks with the Scheduler
[ ]	Simplify management tasks by using the Scheduler
[ ]	Create a job, program, schedule and window
[ ]	Reuse scheduler components for similar tasks
[ ]	View information about job executions and job instances

Space Management
[ ]	Reduce space related error conditions through proactively managing tablespace usage
[ ]	Reclaim wasted space from tables and indexes using the segment shrink functionality
[ ]	Use the Segment Advisor
[ ]	Use the Undo Advisor
[ ]	Use sorted hash clusters

Improved VLDB Support
[ ]	Create and maintain bigfile tablespaces
[ ]	Create temporary tablespace groups
[ ]	Assign temporary tablespace groups to users
[ ]	Skip unuseable indexes
[ ]	Specify storage characteristics for index partitions in the table partition DML commands
[ ]	Create hash-partitioned global indexes
[ ]	Maintain hash-partitioned global indexes

Backup and Recovery Enhancements
[ ]	Simplify file management for all recovery-related files
[ ]	Reduce restore time by applying incremental backups to data file image copies
[ ]	Simplify recovery after opening the database with the RESETLOGS option
[ ]	Speed backup times by creating faster incremental backups

Flashback Any Error
[ ]	Configure and use Flashback Database
[ ]	Recover dropped tables with the Flashback Drop feature
[ ]	Retrieve row history information with the Flashback Versions Query feature
[ ]	Audit or recover FROM transactions with the Flashback Transaction Query feature
[ ]	Recover tables to a point in time with the Flashback Table feature

General Storage Enhancement
[ ]	Create the SYSAUX tablespace
[ ]	Relocate SYSAUX occupants
[ ]	Rename tablespaces
[ ]	Create a default permanent tablespace
[ ]	Copy files using the Database Server
[ ]	Use the Redo Logfile Size Advisor

Automatic Storage Management
[ ]	Describe Automatic Storage Management
[ ]	Set up initialization parameter files for ASM and database instances
[ ]	Execute SQL commands with ASM file names
[ ]	Start up and shut down ASM instances
[ ]	Administer ASM disk groups
[ ]	Use RMAN to migrate your database to ASM

Maintain Software
[ ]	Understand the supported upgrade paths to Oracle Database 10g
[ ]	Use new utility to perform pre-upgrade validation checks
[ ]	Use simplified upgrade process that automatically determines components to be upgraded
[ ]	Start up the database using a new mode when upgrading

Miscellaneous New Features
[ ]	Provide greater flexibility by enabling resumable timeout at the instance level
[ ]	Use regular expression support in SQL and PL/SQL for string searching, matching and replacing
[ ]	Use additional linguistic comparison and sorting methods in SQL
[ ]	Use SQL to flush the buffer cache

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.