oracle 12c ocm考试范围

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 \

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

本文来源：https://www.bwwdw.com/article/rq5g.html