OCM 12c Preparation

Oracle OCM 12c Certification Study project.

Completed 2 of the advanced or specialty courses to meet the hands-on course requirements.

• 

• 

My Books Collections

• 

• 

• 

Oracle Database 12c Certified Master Exam | 12cOCM

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

Notes about t he 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

Minimum Skill-set wise Passing Scores:

Skillset1: Create Database and Network Configurations : 60.29%

Skillset2: Managing Database Availability : 46.93%

Skillset3: Data Warehouse Management : 34.14%

Skillset4: Data Management : 33.92%

Skillset5: Performance Management : 39.13%

Skillset6: Data Guard : 43.39%

Skillset7: Grid Infrastructure : 53.84%

Skillset8: Real Application Cluster Database : 37.83%

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

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

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

Data Guard

• https://hiteshgondalia.wordpress.com/hol-dataguard/
• 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