关于11g OCM升级考试

我的11gOCM升级考试一波三折，终于在前几天收到通过的邮件，个人觉得考试并不很难，升级考主要考11g新特性，考试题目基本上按照考纲来出的，所以对照考纲练习即可，关键是理解透这些新特性，Database, RMAN, EM and Network Configuration 和 Data Guard没有难度，Data and Data Warehouse Management 和Performance Management考试分值比重大，fda, stream,result cache,spa,spm,dbreplay都是考试的重点。

Database, RMAN, EM and Network Configuration

[  ] Configure server-side network
[  ] Configure client-side network
[  ] Create and Manage encrypted tablespaces
[  ] Create and Manage a tablespace that uses NFS mounted file system file
[  ] Set up ADR file based repository
[  ] Perform cold database backup
[  ] Manage user accounts and use case sensitive passwords 
[  ] Use OPatch to install a patch
[  ] Install and configure EM Agent
[  ] Create Base Recovery Catalog
[  ] Configure RMAN
[  ] Perform multisection backup of a datafile
[  ] Create an Archival Backup


Data Guard
[  ] Create Physical Standby Database with real-time apply.
[  ] Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
[  ] Configure the Observer
[  ] Switchover and switch back 
[  ] Convert the standby to a snapshot standby
[  ] Configure archivelog deletion policy for the dataguard configuration
Data and Data Warehouse Management 
[  ] Troubleshoot fast materialized views to fast refresh and query rewrite 
[  ] Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace)
[  ] Configure a schema to support a star transformation query
[  ] Configure and use parallel execution for queries
[  ] Use and access SecureFile LOBS
[  ] Create partitioned tables (includes reference and interval partitioning)
[  ] Configure Flashback Data Archive
[  ] Use Oracle Streams to capture and propagate changes in a table

Data and Data Warehouse Management 
[  ] Troubleshoot fast materialized views to fast refresh and query rewrite 
[  ] Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace)
[  ] Configure a schema to support a star transformation query
[  ] Configure and use parallel execution for queries
[  ] Use and access SecureFile LOBS
[  ] Create partitioned tables (includes reference and interval partitioning)
[  ] Configure Flashback Data Archive
[  ] Use Oracle Streams to capture and propagate changes in a table

Performance Management
[  ] Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc
[  ] Use Result Cache
[  ] Use multi column statistics
[  ] Gather statistics on a specific table without invalidating cursors
[  ] Use partitioned indexes
[  ] Use SQL Tuning Advisor
[  ] Use SQL Access Advisor
[  ] Configure baseline templates 
[  ] Use SQL Plan Management feature
[  ] Replay a captured workload