search
    

    Home Oracle Oracle Database 12c Certified Master Exam (OCM)

    QUICK

    INFORMATION

    icon

    2 Day(s) Course

    icon

    Official Courseware

    icon

    Exam Voucher

    icon

    Certified Trainer

    icon

    1:1 Training Available on Demand

    icon

    Customize Your Batch

    ABOUT

    THE COURSE

    The Oracle Database 12c Certified Master Exam (OCM) is the most advanced Database Administrator credential that validates proven ability of a professional to perform database administration. This 12c OCM exam is based on Oracle Database 12c Release 1 (12.1.0.2.0 - 64-bit) and includes the use of Oracle Real Application Clusters (Oracle RAC). The operating system here used is Oracle Linux Server Release 6.5 (64-bit).

    Oracle Certified Master Credential Requirements

    Obtaining the Oracle Certified Master credential requires a candidate to pass an onsite practical exam that is conducted at designated Oracle University facilities in each global region. A candidate will be tested on his/her competency to perform database administration tasks in a live database environment. As this is the highest credential exam, the skill sets are for the same are timed as well as require a high degree of Oracle database mastery to successfully complete them.

    Before Registering for the 12c OCM Exam the candidate must have/be:

    • Completed PRIOR CERTIFICATION - Oracle Database 12c Administrator Certified Professional (OCP).
    • Completed 2 of the advanced or specialty courses to meet the hands-on course requirements.
    • Gained considerable hands-on expertise fulfilling all of the exam objectives.
    • Familiar with the basic Linux command language.

    1. General Database and Network Administration

    • Creating and managing pluggable databases
    • Administering users, roles, and privileges
    • Configuring the network environment to allow connections to multiple databases
    • Administering database configuration files
    • Configuring shared server
    • Managing network file directories

    2. Manage Database Availability

    • Installing the EM Cloud Control agent
    • Configuring recovery catalog
    • Configuring RMAN
    • Performing a full database backup
    • Configuring and monitoring Flashback Database

    3. Data Warehouse Management

    • Managing database links
    • Managing a fast refreshable materialized view
    • Creating a plug-in tablespace by using the transportable tablespace feature
    • Optimizing star queries
    • Configuring parallel execution
    • Applying a Patch
    • Configuring Automatic Data Optimization, In-Row Archiving, and Temporal Validity
    • Managing external tables

    4. Data Management

    • Managing additional buffer cache
    • Optimizing space usage for the LOB data
    • Managing an encrypted tablespace
    • Managing schema data
    • Managing partitioned tables
    • Setting up Fine-Grained Auditing
    • Configuring the database to retrieve all previous versions of the table rows

    5. Performance Management

    • Configuring the Resource Manager
    • Tuning SQL statements
    • Using real application testing
    • Managing SQL Plan baselines
    • Capturing performance statistics
    • Tuning an instance - Configure and manage result cache, Control CPU use for Oracle Instances
    • Managing extended statistics
    • Creating and managing partitioned indexes

    6. Data Guard

    • Administering a Data Guard environment
    • Creating a physical standby database
    • Configuring a standby database for testing
    • Configuring a standby database to apply redo
    • Configuring a standby database to use for reporting
    • Configuring fast start failover
    • Managing extended statistics
    • Managing DDL in a Data Guard environment

    7. Grid Infrastructure

    • Installing Oracle Grid Infrastructure
    • Creating ASM Disk Groups
    • Creating and managing ASM instances
    • Configuring ASM Cloud File System (ACFS)
    • Administering Oracle Clusterware
    • Managing Flex Clusters and Flex ASM
    • Managing Flex Clusters and Flex ASM

    8. Real Application Cluster Database

    • Installing Oracle Database software
    • Creating a Real Application Clusters (RAC) database
    • Configuring Database Services
    • Administering Oracle RAC databases on one or more cluster nodes

    The Oracle Database 12c Oracle Certified Master Certification Exam is for:
    • Database administrator
    • Support engineer
    • Technical Consultant

    Required:

    • Candidate must possess a minimum of 3 – 4 years of Oracle database administrator experience.
    • Should have completed 2 of the Advanced or Specialty courses to meet the Hands On Course Requirements.
    • Every candidate should have their 9-character Oracle Testing ID to initiate the OCM exam.
    • Complete PRIOR CERTIFICATION -Oracle Database 12c Administrator Certified Professional (OCP)

    Suggested Prerequisites:

    • Advanced knowledge and use of Oracle Enterprise Server
    • Familiarity navigating through online Oracle documentation
    • Proficient with using Mozilla browser software
    • Proficient with SQL

    Name Code Fee

    gorm icon

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.5 stars by www.facebook.com/mercurysol based on 17 reviews.