Oracle Database 11g Certified Master Upgrade Exam

Exam Topics :

Oracle 11g OCM upgrade exam will be covering four task covering the following.

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 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