Oracle Database 12c Certified Master (OCM) Exam Information
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 12.1.0.2.0.
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 12.1.0.2.0 64 bit· Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)· Oracle Enterprise Manager Cloud Control 12c Rel 4.
Section-:
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-:
Step-1-:
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)
Step-2-:
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.
Courses-:
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
Step-3-:
Submit these archived courses that you have already completed
Step-4-:
Pass Exam
Step-5-:
Course Submission Form
https://education.oracle.com/certification-training-course-submission-form-verification
Step-6-:
Complete this form. Submit Fulfillment Kit Request. This form is submitted exactly the same as the Course Submission Form.
Suggestion-:
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.
Cheers!!!!
With Best Wishes!!!!
Ahmad
Oracle Consultant
OCS (12c GG)
OCE (11gR2 RAC)
OCP (11gR2/10gR2/9iR2)
OCA (9i R2)
2 Comments
Rafi · December 11, 2019 at 7:40 pm
Really very good post and useful
Rauf · February 25, 2020 at 5:40 pm
Excellent