Oracle Database 11g ocp认证考试内容: New Features for Administrators
建议课程及准备Oracle University training and preparation:
http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D50081]Oracle Database 11g: New Features for Administrators Release 2
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D74967GC10]Oracle Database 11g: New Features for Administrators Ed 1 TOD

Oracle PartnerNetwork training and preparation:
https://competencycenter.oracle.com/opncc/glp_list.cc]Training Opportunities for Oracle Partner Network Members
OPN Guided Learning Path: https://competencycenter.oracle.com/opncc/full_glp.cc?group_id=11524]Oracle Database 11g Implementation Specialist
http://www.oracle.com/partners/en/knowledge-zone/database/oracle-database-11g/1z0-050-resources-169368.html]Training Resources by Exam Topics

The earlier course is still a valid exam preparation tool but is no longer being scheduled:
Oracle Database 11g: New Features for Administrators

The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0

Exam Topics[table=98%]
[td=33%]
[td=2,1]Installation and Upgrade Enhancements
[td=31][ ]Install Oracle Database 11g
[td=31][ ]Upgrade your database to Oracle Database 11g
[td=31][ ]Oracle Direct NFS
[td=31][ ]Use online patching
[td=2,1]Storage Enhancements
[td=31][ ]Setup ASM fast mirror resynch
[td=31][ ]Understand scalability and performance enhancements
[td=31][ ]Setup ASM disk group attributes
[td=31][ ]Use various new manageability options
[td=31][ ]Use the md_backup, md_restore, and ASMCMD extensions
[td=2,1]Intelligent Infrastructure Enhancements
[td=31][ ]Creating and using AWR baselines
[td=31][ ]Setting AWR Baseline Metric Thresholds
[td=31][ ]Control Automated Maintenance Tasks
[td=31][ ]Using Database Resource Manager New Features
[td=31][ ]Using new scheduler features
[td=2,1]Performance Enhancements
[td=31][ ]ADDM Enhancements
[td=31][ ]Setup Automatic Memory Management
[td=31][ ]Enhancements in statistics collection
[td=2,1]Partitioning and Storage-Related Enhancements
[td=31][ ]Implement the new partitioning methods
[td=31][ ]Employ Data Compression
[td=31][ ]SQL Access Advisor Overview
[td=31][ ]Create SQL Access Advisor analysis session using PL/SQL
[td=2,1]Using RMAN Enhancements
[td=31][ ]Managing Archive logs
[td=31][ ]Duplicating a Database
[td=31][ ]Back up large files in multiple sections
[td=31][ ]Perform Archival Backups
[td=31][ ]Manage Recovery Catalogs
[td=31][ ]Create a virtual private catalog for RMAN
[td=33%]
[td=2,1]Using Flashback and Logminer
[td=31][ ]Overview of Flashback Data Archive
[td=31][ ]Manage Flashback Data Archive
[td=31][ ]Back-out transactions using Flashback Transaction
[td=31][ ]Working with Logminer
[td=2,1]Diagnosability Enhancements
[td=31][ ]Setup Automatic Diagnostic Repository
[td=31][ ]Use Support Workbench
[td=31][ ]Run health checks
[td=31][ ]Use SQL Repair Advisor
[td=2,1]Database Replay
[td=31][ ]Overview of Workload Capture and Replay
[td=31][ ]Using Workload capture and replay
[td=2,1]Using the Data Recovery Advisor
[td=31][ ]Overview of Data Recovery Advisor
[td=31][ ]Repairing data failures using Data Recovery Advisor
[td=31][ ]Perform proactive health check of the database
[td=2,1]Security: New Features
[td=31][ ]Configure the password file to use case sensitive passwords
[td=31][ ]Encrypt a tablespace
[td=31][ ]Configure fined grained access to network services
[td=2,1]Oracle SecureFiles
[td=31][ ]Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
[td=31][ ]Use SQL and PL/SQL APIs to access Secure File LOBS
[td=33%]
[td=2,1]Miscellaneous New Features
[td=31][ ]Describe and use the enhanced online table redefinition
[td=31][ ]Enhanced finer grained dependency management
[td=31][ ]Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
[td=31][ ]Use Query Result Cache and PL/SQL Result Cache
[td=31][ ]Adaptive Cursor Sharing
[td=31][ ]Temporary Tablespace Enhancements
[td=2,1]SQL Performance Analyzer
[td=31][ ]Overview of SQL Performance Analyzer
[td=31][ ]Using SQL Performance Analyzer
[td=2,1]SQL Plan Management
[td=31][ ]SQL Plan Baseline Architecture
[td=31][ ]Set up SQL Plan Baseline
[td=31][ ]Using SQL Plan Baseline
[td=2,1]Automatic SQL Tuning
[td=31][ ]Setup and modify Automatic SQL Tuning
[td=31][ ]Interpret reports generated by Automatic SQL Tuning