上海涛德顾问学院

Oracle 12c OCM认证考试内容

摘要: Oracle 12c OCM认证考试内容 涛德Oracle 12c 认证培训(Oracle OCM考官执教)大纲请点击:http://www.oraclebi.net/Oracle_12c_OCM/ Oracle 12c OCM认证考试内容如下: 考试分为8个模块,2天考完 这8个模块为: 一 ...

Oracle 12c OCM认证考试内容

 

涛德Oracle 12c 认证培训(Oracle OCM考官执教)大纲请点击:http://www.oraclebi.net/Oracle_12c_OCM/

 

Oracle 12c OCM认证考试内容如下:

考试分为8个模块,2天考完

8个模块为:

一: 数据库管理与网络配置

 

Create and manage pluggable databases.

Create and manage users, roles, and privileges.

Configure the network environment to allow connections to multiple databases.

Create and manage database configuration files.

 

:管理数据库可用性

 

Install the EM Cloud Control agent?Configure recovery catalog.

Configure RMAN.

Perform a full database backup.

Configure and monitor Flashback Database.

 

数据仓库管理

Create a database link.

Create 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

 

 

数据管理

Create an additional buffer cache.

Optimize space usage for the LOB data.

Create an encrypted tablespace.

Manage schema data.

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

Perform real application testing.

Create SQL Plan baselines.

Capture performance statistics.

Tune an instance

 

 

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.

 

Grid Infrastructure GI集群安装与配置

Install Oracle Grid Infrastructure.

Create ASM Disk Groups.

Create and manage ASM instances.

Configure ASM Cloud File System (ACFS).

Administer Oracle Clusterware.

 

Real Application Cluster Database数据库集群

Install Oracle Database software

Create a Real Application Clusters (RAC) database

Configure Database Services.

 

考试环境如下:

 

Oracle Linux Release 6.5 64 bit

Mozilla Browser, Text  and  vi editors

Shell environment: bash, csh

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

 

相关阅读

联系

上海涛德顾问学院 ( 沪ICP备14006824号 )  

GMT+8, 2018-12-15 02:46 , Processed in 0.140264 second(s), 15 queries , Gzip On.

Top Data World

回顶部