OCM 12c 直考预备知识点

考试环境

• 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

分数线

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

Skillset 1-General Database and Network Administration

• 1-1 Create and manage pluggable databases [施工中]
• 1-2 Administer users, roles, and privileges
• 1-3 Configure the network environment to allow connections to multiple databases
• 1-4 Administer database configuration files
• 1-5 Configure shared server
• 1-6 Manage network file directories

SkillSet 2-Manage Database Availability

• 2-1 Install the EM Cloud Control agent
• 2-2 Configure recovery catalog
• 2-3 Configure RMAN
• 2-4 Perform a full database backup
• 2-5 Configure and monitor Flashback Database

SkillSet 3-Data Warehouse Management

• 3-1 Manage database links
• 3-2 Manage a fast refreshable materialized view
• 3-3 Create a plug-in tablespace by using the transportable tablespace feature
• 3-4 Optimize star queries
• 3-5 Configure parallel execution
• 3-6 Apply a Patch
• 3-7 Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
• 3-8 Manage external tables

SkillSet 4-Data Management

• 4-1 Manage additional buffer cache
• 4-2 Optimize space usage for the LOB data
• 4-3 Manage an encrypted tablespace
• 4-4 Manage schema data
• 4-5 Manage partitioned tables
• 4-6 Set up Fine-Grained Auditing
• 4-7 Configure the database to retrieve all previous versions of the table rows

SkillSet 5-Performance Management

• 5-1 Configure the Resource Manager
• 5-2 Tune SQL statements
• 5-3 Use real application testing
• 5-4 Manage SQL Plan baselines
• 5-5 Capture performance statistics
• 5-6 Tune an instance
• 5-7 Configure and manage result cache
• 5-8 Manage extended statistics
• 5-9 Create and manage partitioned indexes
• 5-10 Control CPU use for Oracle Instances
• 5-11 Configure and manage “In Memory” features

6-Data Guard

• 6-1 Administer a Data Guard environment
• 6-2 Create a physical standby database
• 6-3 Configure a standby database for testing
• 6-4 Configure a standby database to apply redo
• 6-5 Configure a standby database to use for reporting
• 6-6 Configure fast start failover
• 6-7 Manage DDL in a Data Guard environment

7-Grid Infrastructure

• 7-1 Install Oracle Grid Infrastructure
• 7-2 Create ASM Disk Groups
• 7-3 Create and manage ASM instances
• 7-4 Configure ASM Cloud File System (ACFS)
• 7-5 Administer Oracle Clusterware
• 7-6 Manage Flex Clusters and Flex ASM

8-Real Application Cluster Database

• 8-1 Install Oracle Database software
• 8-2 Create a Real Application Clusters (RAC) database
• 8-3 Configure Database Services
• 8-4 Administer Oracle RAC databases on one or more cluster nodes