OCM 12c Preparation

Oracle Certified Master is one of the prestigious exam in database world. Most of the Oracle DBA have a dream to be OCM certified. This certification will distinguish you from others in Market.

Prerequisites to be OCM Certified: Details

Oracle 12c OCM exam is based on Oracle Database 12c Release 1 and includes the use of Oracle Real Application Clusters (Oracle RAC). The operating system is Oracle Linux Server Release 6.5.

Exam Environment

https://education.oracle.com/oracle-database-12c-certified-master-exam/pexam_12cOCM

  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release 12.1.0.2.0  64 bit
  • Oracle Grid Infrastructure 12Release 1 (12.1.0.2)
  • Oracle Enterprise Manager Cloud Control 12c Rel 4

Minimum Skill-set wise Passing Scores:

  • Skill Set 1 : Create Database and Network Configurations : 60.29%
  • Skill Set 2 : Managing Database Availability : 46.93%
  • Skill Set 3 : Data Warehouse Management : 34.14%
  • Skill Set 4 : Data Management : 33.92%
  • Skill Set 5 : Performance Management : 39.13%
  • Skill Set 6 : Data Guard : 43.39%
  • Skill Set 7 : Grid Infrastructure : 53.84%
  • Skill Set 8 : Real Application Cluster Database : 37.83%

Passing Score : 59.95%

Exam Topics:

General Database and Network Administration 
  • 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

Data Warehouse Management 

  • 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

Performance Management 

  • 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

Manage Database Availability 

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

Data Management 

  • 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

Data Guard

  • 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

  • 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

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

Leave a Reply