Oracle Database 10g: Administration II

Exam Number:	1Z0-043
Associated Certifications:	Oracle Database 10g Database Administrator Oracle Certified Professional
Exam Price:	$125.00 USD
Exam Registration:	Register

Duration:

90 minutes

Number of Questions:

Passing Score:

70%

Passing score subject to change. View Details

Recommended Training and Preparation

Oracle Database 10g: Administration Workshop II
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.
OR
Oracle Database 10g: Administration Workshop II Ed 3 LVC

Oracle Database 10g: Administration Workshop 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-043 Oracle Database 10g: Administration II
Oracle authorized practice exam from Transcender: DBCert: Database 10g: Administration II

Oracle 10g Database Administrator Candidate Guide
Exam Retake Policy
Sample Questions

Exam Topics

Using Globalization Support Objectives
[ ]	Customize language-dependent behavior for the database and individual sessions
[ ]	Specify different linguistic sorts for queries
[ ]	Use datatime datatypes
[ ]	Query data using case insensitive and accent insensitive searches
[ ]	Obtain Globalization support configuration information

Configuring Recovery Manager
[ ]	Configure database parameters that affect RMAN operations
[ ]	Change RMAN default settings with CONFIGURE
[ ]	Manage RMAN's persistent settings
[ ]	Start RMAN utility and allocate channels

Recovering from User Errors
[ ]	Recover a dropped table using Flashback technology
[ ]	Perform Flashback table operation
[ ]	Manage the recycle bin
[ ]	Recover from user errors using Flashback versions query
[ ]	Perform transaction level recovery using Flashback Transaction query

Dealing with Database Corruption
[ ]	Define block corruption and list its causes and symptoms
[ ]	Detect database corruptions using the following utilities: ANALYZE DBVERIFY
[ ]	Detect database corruptions using the dbms_repair package
[ ]	Implement the DB_BLOCK_CHECKING parameter to detect corruptions
[ ]	Repair corruptions using RMAN
Automatic Database Management
[ ]	Use the Database Advisors to gather information about your database
[ ]	Use the SQL Tuning Advisor to improve database performance
[ ]	Use automatic undo retention tuning

Using Recovery Manager
[ ]	Use the RMAN BACKUP command to create backup sets and image copies
[ ]	Enable block change tracking
[ ]	Manage the backups and image copies taken with RMAN with the LIST and REPORT commands

Recovering from Non-Critical Losses
[ ]	Recover temporary tablespaces
[ ]	Recover a redo log group member
[ ]	Recover index tablespaces
[ ]	Recover read-only tablespaces
[ ]	Recreate the password file

Monitoring and Managing Storage
[ ]	Tune redo writing and archiving operations
[ ]	Issue statements that can be suspended upon encountering space condition errors
[ ]	Reduce space-related error conditions by proactively managing tablespace usage
[ ]	Reclaim wasted space from tables and indexes using the segment shrink functionality
[ ]	Estimate the size of new table and indexes
[ ]	Use different storage options to improve the performance of queries
[ ]	Rebuild indexes online
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

Monitoring and Managing Memory
[ ]	Implement Automatic Shared Memory Management
[ ]	Manually configure SGA parameters for various memory components in the SGA
[ ]	Use Automatic PGA Memory Management

Database Recovery
[ ]	Recover the control file
[ ]	Explain reasons for incomplete recovery
[ ]	Perform incomplete recovery using EM
[ ]	Perform incomplete recovery using RMAN
[ ]	Perform incomplete recovery using SQL
[ ]	Perform database recovery following a RESETLOGS operation
Flashback Database
[ ]	Determine which flashback technology to use for each recovery situation
[ ]	Configure and use Flashback Database
[ ]	Monitor the Flashback Database
[ ]	Use the Enterprise Manager Recovery Wizard to flashback database
[ ]	Manage (or maintain) the Flash Recovery Area

Managing Resources
[ ]	Configure the Resource Manager
[ ]	Assign users to Resource Manager groups
[ ]	Create resource plans within groups
[ ]	Specify directives for allocating resources 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

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.