Oracle 11g OCM - Oracle Database 11g Certified Master Exam

Exam Topics:

Oracle 11g OCM upgrade exam will be covering Eight Scenario's covering the following in 2 Full day Exam :

Server Configuration [  ] Create the database [  ] Determine and set sizing parameters for database structures [  ] Create and manage temporary, permanent, and undo tablespaces [  ] Stripe data files across multiple physical devices and locations [  ] Configure the database environment to support optimal data access performance [  ] Create and manage database configuration files [  ] Create and manage bigfile tablespaces [  ] Create and Manage a tablespace that uses NFS mounted file system file [  ] Create and manage multiple network configuration files [  ] Create and configure a listener [  ] Configure the database instance to support shared server connections [  ] Set up network tracing [  ] Manage Oracle network processes [  ] Configure the network environment to allow connections to multiple databases [  ] Use configurationless connections [  ] Use Grid Infrastructure to manage oracle databases and other resources. Enterprise Manager Grid Control [  ] Install and Patch Enterprise Manager Grid Control software [  ] Configure the Enterprise Manager repository [  ] Create Enterprise Manager Grid Control users [  ] Use Enterprise Manager to modify a database configuration [  ] Configure Enterprise Manager to modify a database availability [  ] Create and manage jobs [  ] Create and monitor alerts [  ] Create notifications [  ] Implement Grid Control and Database Control [  ] Choose the appropriate tablespace type for the intended use [  ] Create Scheduler jobs [  ] Create schedules [  ] Assign jobs to windows [  ] Create programs [  ] Create job classes [  ] Install the Enterprise Manager Grid Control infrastructure [  ] Deploy Enterprise Manager Grid Control agents [  ] Configure Grid Control for business requirements  For more detail Follow :-

Managing Database Availability [  ] Mantain recovery catalogs. [  ] Configure Recovery Manager [  ] Use Recovery Manager to perform database backups [  ] Use Recover Manager to perform complete database restore and recovery operations [  ] Configure RMAN [  ] Create different types of RMAN backups to cater for different performance and retention requirements [  ] Set Flashback Database parameters [  ] Configure a Fast Recovery Area [  ] Perform various recovery operations using Flashback technology  Data Management [  ] Manage Materialized Views to improve rewrite and refresh performance [  ] Configure and manage distributed materialized views [  ] Create and Manage encrypted tablespaces [  ] Manage Transport of tablespaces across platforms [  ] Configure a schema to support a star transformation query [  ] Administer external tables [  ] Implement Data Pump export and import jobs for data transfer [  ] Implement Data Pump to and from remote databases [  ] Configure and use parallel execution for queries [  ] Use SQL*Loader [  ] Administer, manage and tune parallel execution Data Warehouse Management [  ] Administer partitioned tables and indexes using appropriate methods and keys [  ] Perform partition maintenance operations [  ] Maintain indexes on a partitioned table [  ] Implement securefile LOB [  ] Create and manage LOB segments [  ] Implement fine-grained access control [  ] Create and manage contexts [  ] Administer flashback data archive and schema evolution [  ] Configure and Manage Streams for Capture, Propagation and Apply.

Performance Management [  ] Administer Resource Manager [  ] Use Result Cache [  ] Use multi column statistics [  ] Gather statistics on a specific table without invalidating cursors [  ] Use partitioned indexes [  ] Administer and tune schema object to support various access methods [  ] Interpret execution plan [  ] Use SQL tuning tools and features [  ] Use SQL Tuning Advisor [  ] Use SQL Access Advisor [  ] Use SQL Performance Analyzer [  ] Configure baseline templates [  ] Use SQL Plan Management feature [  ] Implement instance caging Real Application Clusters [  ] Install Oracle Grid Infrastructure [  ] Create ASM Disk Groups [  ] Create and manage as ASM instance [  ] Creating ACFS File System [  ] Start,Stop Configure and Administer Oracle Grid Infrastructure [  ] Install the Oracle Database 11gR2 software [  ] Configure ASM for the shared disks and create a clustered database [  ] Implement ASM failure groups [  ] Configure archiving [  ] Configure Services using both Manual and Policy Managed Methods 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 [  ] configure connect time failover [  ] Convert the standby to a snapshot standby [  ] Configure archivelog deletion policy for the dataguard configuration

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=&lang=&p_exam_id=11gOCM