19C OCM考试之一:考试大纲

郑全

停了一段时间的ORACLE 12c OCM考试,终于又从2023年3月份开始，重新以新版本ORACLE 19C OCM的形式出现，那么，19C OCM考试，考试内容有什么变化呢

我们知道，以前的OCM考试，有8个场景，每个场景都有最低分数线，现在19C OCM，合并成 4个 场景,同样也有过关分数线,我们今天先来看看19c OCM考试什么内容吧

1.General database and network administration

·        Create a pluggable database

·        Create tablespace

·        Managing undo

·        Manage application containers

·        Network configuration

·        Shared server configuration

·        Control file management

·        Managing Pluggable Databases

2. Backup/Recovery

·        Configure Recovery Catalog

·        Perform recovery and duplication

·        Perform backup and backup configuration

·        Configuring Flashback Database

3. Data management

·        Memory management

·        Plugging in tablespaces and creating external tables

·        Manage tablespaces

·        Managing Partitioning

·        Configuration that allows searching of previous versions of data

·        Star query optimization

·        Managing materialized views

·        Auditing

·        Additional configuration

4.Performance management

·        Create synonym

·        Configure Resource Manager

·        SQL statement tuning

·        Create appropriate schema objects

·        Configuring parallel execution

·        Instance tuning

5. Configuring Data Guard

·        Create a standby database

·        Configuring the standby database for testing purposes

·        Other Standby Database Configurations

·        Administration automation

·        Perform switchover

6. Configuring Real Application Clusters

·        Enabling Grid Infrastructure

·        Administering ASM disk groups

·        Managing Grid Infrastructure

·        Creating a RAC database

·        Additional configuration