search
    

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

    QUICK

    INFORMATION

    course-duration

    2 Day(s) Course

    courseware

    Official Courseware

    exam-voucher

    Exam Voucher

    certified-trainer

    Certified Trainer

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    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

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

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