OCM 12c

Passing score information – D91805GC20
Overall Passing Score: 59.95%

General Database and Network Administration (PS 60.29%)

• Create and manage pluggable databases
• Administer users, roles, and privileges
• Configure the network environment to allow connections to multiple databases
• Administer database configuration files
• Configure shared server
• Manage network file directories

Manage Database Availability (PS 46.93%)

• Install the EM Cloud Control agent?Configure recovery catalog
• Configure RMAN
• Perform a full database backup
• Configure and monitor Flashback Database

Data Warehouse Management (PS 34.12%)

• Manage database links
• Manage a fast refreshable materialized view
• Create a plug-in tablespace by using the transportable tablespace feature
• Optimize star queries
• Configure parallel execution
• Apply a Patch
• Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
• Manage external tables

Data Management (PS 33.92%)

• Manage additional buffer cache
• Optimize space usage for the LOB data
• Manage an encrypted tablespace
• Manage schema data
• Manage partitioned tables
• Set up Fine-Grained Auditing
• Configure the database to retrieve all previous versions of the table rows

Performance Management (PS 39.13%)

• Configure the Resource Manager
• Tune SQL statements
• Use real application testing
• Manage SQL Plan baselines
• Capture performance statistics
• Tune an instance
• Configure and manage result cache
• Manage extended statistics
• Create and manage partitioned indexes
• Control CPU use for Oracle Instances
• Configure and manage “In Memory” features

Data Guard (PS 43.39%)

• Administer a Data Guard environment
• Create a physical standby database
• Configure a standby database for testing
• Configure a standby database to apply redo
• Configure a standby database to use for reporting
• Configure fast start failover
• Manage DDL in a Data Guard environment

Grid Infrastructure (PS 53.84%)

• Install Oracle Grid Infrastructure
• Create ASM Disk Groups
• Create and manage ASM instances
• Configure ASM Cloud File System (ACFS)
• Administer Oracle Clusterware
• Manage Flex Clusters and Flex ASM

Real Application Cluster Database (PS 37.83%)

• Install Oracle Database software
• Create a Real Application Clusters (RAC) database
• Configure Database Services
• Administer Oracle RAC databases on one or more cluster nodes