当前位置:首页>微思动态 > >详情
全国热线电话 400-881-4699

在线留言

【考试】Oracle OCM考试介绍

发布作者:微思网络   发布时间:2020-09-29   浏览量:0


Oracle Database 12c Certified Master Exam | 12c OCM    


        12c OCM 不同于 11g OCM,后者 2 天 9 场景,核算总分,60 即通过;而前者不仅算总分,且在 2 天 8 场景的考试中,每个场景都有最低分数线,相对于 11g OCM 来说,通过难度更大一些。 


        本篇考试介绍将从考试环境(操作系统版本、各个软件版本等)、技能及最低分数线复习考试内容(每场景考试的具体知识点)和彩蛋(答疑)四个方面来展示 12c OCM 直考的相关内容。


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 12Release 1 (12.1.0.2)

  • Oracle Enterprise Manager Cloud Control 12c Rel 4


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%


Review Exam Topics

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


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


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

  • 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


        什么?你觉得上面这些看着挺费力?哦我的朋友,从现在开始,你要培养和提升自己对英文的敏感度,不要求我们必须做到信雅达的翻译,但,至少看到可以理解是什么意思。因为 OCM 考试目前只有英文和日文两种语言。


常见问题:

  • 没有 OCP培训可以直接报考 12c OCM 吗?不可以,必须先获取12c OCP

  • 11g OCP 可以报考 12c OCM 吗? 不可以,必须先升级 12c OCP

  • 11g OCM 可以报考 12c OCM 吗?可以,参加 1 天 4 门升级考试


返回顶部