Oracle Database 11g: New Features for Administrators

Exam Number:	1Z0_050
Associated Certifications:	Oracle Database 11g DBA OCP OPN Certified Specialist
Exam Price:	$125 US
Exam Registration:	Register

Duration:

105 minutes

Number of Questions:

Passing Score:

61%

Passing score subject to change. View Details

Recommended Training and Preparation

Oracle Database 11g: New Features for Administrators
Training Opportunities for Oracle Partner Network Members

Additional Information & Resources

Practice Exams

Oracle authorized practice exam from Self Test Software: 1Z0-050 Oracle Database 11g New Features
Oracle authorized practice exam from Transcender Cert-1Z0-050 DBCert: Oracle 11g Database New Features

Exam Retake Policy
Sample Questions

Exam Topics

Installation and Upgrade Enhancements
[ ]	Install Oracle Database 11g
[ ]	Upgrade your database to Oracle Database 11g
[ ]	Oracle Direct NFS
[ ]	Use online patching
Storage Enhancements
[ ]	Setup ASM fast mirror resynch
[ ]	Understand scalability and performance enhancements
[ ]	Setup ASM disk group attributes
[ ]	Use various new manageability options
[ ]	Use the md_backup, md_restore, and ASMCMD extensions
Intelligent Infrastructure Enhancements
[ ]	Creating and using AWR baselines
[ ]	Setting AWR Baseline Metric Thresholds
[ ]	Control Automated Maintenance Tasks
[ ]	Using Database Resource Manager New Features
[ ]	Using new scheduler features
Performance Enhancements
[ ]	ADDM Enhancements
[ ]	Setup Automatic Memory Management
[ ]	Enhancements in statistics collection
Partitioning and Storage-Related Enhancements
[ ]	Implement the new partitioning methods
[ ]	Employ Data Compression
[ ]	SQL Access Advisor Overview
[ ]	Create SQL Access Advisor analysis session using PL/SQL
Using RMAN Enhancements
[ ]	Managing Archive logs
[ ]	Duplicating a Database
[ ]	Back up large files in multiple sections
[ ]	Perform Archival Backups
[ ]	Manage Recovery Catalogs
[ ]	Create a virtual private catalog for RMAN

Using Flashback and Logminer
[ ]	Overview of Flashback Data Archive
[ ]	Manage Flashback Data Archive
[ ]	Back-out transactions using Flashback Transaction
[ ]	Working with Logminer
Diagnosability Enhancements
[ ]	Setup Automatic Diagnostic Repository
[ ]	Use Support Workbench
[ ]	Run health checks
[ ]	Use SQL Repair Advisor
Database Replay
[ ]	Overview of Workload Capture and Replay
[ ]	Using Workload capture and replay
Using the Data Recovery Advisor
[ ]	Overview of Data Recovery Advisor
[ ]	Repairing data failures using Data Recovery Advisor
[ ]	Perform proactive health check of the database
Security: New Features
[ ]	Configure the password file to use case sensitive passwords
[ ]	Encrypt a tablespace
[ ]	Configure fined grained access to network services
Oracle SecureFiles
[ ]	Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
[ ]	Use SQL and PL/SQL APIs to access Secure File LOBS

Miscellaneous New Features
[ ]	Describe and use the enhanced online table redefinition
[ ]	Enhanced finer grained dependency management
[ ]	Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
[ ]	Use Query Result Cache and PL/SQL Result Cache
[ ]	Adaptive Cursor Sharing
[ ]	Temporary Tablespace Enhancements
SQL Performance Analyzer
[ ]	Overview of SQL Performance Analyzer
[ ]	Using SQL Performance Analyzer
SQL Plan Management
[ ]	SQL Plan Baseline Architecture
[ ]	Set up SQL Plan Baseline
[ ]	Using SQL Plan Baseline
Automatic SQL Tuning
[ ]	Setup and modify Automatic SQL Tuning
[ ]	Interpret reports generated by Automatic SQL Tuning

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.