Oracle Database 12c Certified Master (OCM) Exam Information

Published by Ahmad on

I am writing this post because i am getting too many queries for OCM 12c Exam. Because this is the last exam of the database category.
Exam Details-:
Duration: 2 days·         

Passing Score: 59.95%·         

Validated Against: This exam has been validated against Oracle Database 12c Enterprise Edition Release
Exam Environment-:
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 64 bit·         
Oracle Grid Infrastructure 12c Release 1 (·         
Oracle Enterprise Manager Cloud Control 12c Rel 4.
There are 8 Section in OCM 12c Exam.
Minimum Skill-set wise Passing Scores-:
Skillset-1 : Create Database and Network Configurations -: 60.29%·         

Skillset-2: Managing Database Availability -: 46.93%·         

Skillset-3: Data Warehouse Management -: 34.14%·         

Skillset-4: Data Management -: 33.92%·         

Skillset-5: Performance Management -: 39.13%·         

Skillset-6: Data Guard -: 43.39%·         

Skillset-7: Grid Infrastructure -: 53.84%·         

Skillset-8: Real Application Cluster Database -: 37.83%

Exam Topics -:
 1-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.

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

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

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

5-Manage Database Availability 
Install the EM Cloud Control agent?

Configure recovery catalog·

Configure RMAN·

Perform a full database backup·

Configure and monitor Flashback Database.

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

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

8-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
Notes about the exam -:
Exam participants work through eight skillsets that are based on the exam objectives.

Tasks can be performed using CLI or GUI environment and tools when available

Pre-Requisites for Registration-:
Complete this prior certification
Candidate must have one of the following certifications.
Oracle Database 12c Administrator Certified Professional (OCP)
Database 12cR2 Administration Certified Professional (OCP)
Oracle Database Administration 2019 Certified Professional (OCP)
Complete two of these below courses
Candidates must complete TWO of the advanced courses below.
Courses used to fulfill the OCP training requirement may not be used again to fulfill the OCM training requirement. Must be different courses and not 2 versions of the same course.
A higher version of any of the above courses will also fulfill the training requirement.Course must be delivered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner Oracle Academy or Oracle Workforce Development Program.Courses can be instructor-led in-class (ILT), a live virtual class (LVC), training on demand (TOD), or Learning Subscription.
Note--: Self-study courses (labeled as 'Self-Study’ in the course format) are great preparation tools, but do not fulfill the training requirement.

Exadata Database Machine: 12c Administration Workshop
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: High Availability New Features
Oracle Database 12c: Managing Multitenant Architecture
Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: RAC Administration
Oracle Database 12c: Security
Oracle Database 12c: Use XML DB
Oracle Database 12c: Performance Management and Tuning
Oracle Database 12c: Advanced PL/SQL
Oracle Database: SQL Tuning for Developers
Oracle Enterprise Manager Cloud Control 12c: Adv Config Workshop
Oracle Enterprise Manager Cloud Control 12c: Cloud Mgmt Workshop
Oracle Enterprise Manager Ops Center 12c Administration
Using Oracle Enterprise Manager Cloud Control 12c
Oracle Database 12c: Administration Workshop
Oracle Database 12c: Backup and Recovery Workshop
Oracle Database 12c: ASM Administration
Oracle Database 12c: Install and Upgrade Workshop
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Oracle Database 12c: Clusterware & RAC Admin Accelerated
Oracle Database 12c: OCM Exam Preparation Workshop

Submit these archived courses that you have already completed
Pass Exam
Course Submission Form


Complete this form. Submit Fulfillment Kit Request. 

This form is submitted exactly the same as the Course Submission Form.

Practice 4 hours every day on weekdays (28 hours)

Practice 8 hours on weekend (16 hours)

If you follow these schedules you can able to get prepared in about 3 months.

With Best Wishes!!!!
Oracle Consultant
OCS (12c GG)
OCE (11gR2 RAC)
OCP (11gR2/10gR2/9iR2)

OCA (9i R2)

OracleRide Team!!!!
Reference –:


Rafi · December 11, 2019 at 7:40 pm

Really very good post and useful

Rauf · February 25, 2020 at 5:40 pm


Leave a Reply

Your email address will not be published. Required fields are marked *