| Topic | Details |
| Topic 1 | - Moving Data: This section evaluates the expertise of Data Migration Specialists in moving data within Oracle databases. It includes using external tables, executing Oracle Data Pump operations, and distinguishing SQL*Loader commands for importing data efficiently.
|
| Topic 2 | - Configuring Oracle Net Services: This section measures the skills of Network Administrators and Database Administrators in configuring Oracle Net Services. It includes identifying administration components, describing connection methods, and ensuring seamless communication between clients and databases.
|
| Topic 3 | - Managing Storage: This section tests the knowledge of Storage Engineers in managing storage features such as resumable space allocation, segment space-saving, and block space management. It also includes defining segment characteristics to optimize storage utilization.
|
| Topic 4 | - Managing Users, Roles, and Privileges: This domain evaluates the expertise of Security Administrators in implementing user security measures. It focuses on creating and managing users, roles, and privileges to ensure secure access to Oracle databases.
|
| Topic 5 | - Displaying Creating and Managing PDBs: This section assesses the knowledge of Cloud Database Architects in creating pluggable databases (PDBs) from seeds or other techniques. It also covers modifying PDB modes and attributes to meet specific application requirements.
|
| Topic 6 | - Managing Tablespaces and Datafiles: This section assesses the abilities of Storage Administrators in creating, modifying, and describing tablespaces. It also covers recognizing data storage requirements and understanding datafile placement for efficient storage management.
|
| Topic 7 | - Introduction to Performance: This section evaluates the expertise of Performance Analysts in summarizing Oracle database performance management techniques. It includes measuring database performance using SQL execution plans, directives, and advisors to ensure optimal system efficiency.
|
| Topic 8 | - Managing Undo: This domain measures the skills of Database Administrators in using undo data effectively. It compares undo data with redo data and explains temporary undo usage for efficient transaction management.
|
| Topic 9 | - Describe Oracle Database Architecture: This section of the exam measures the skills of Database Administrators and System Architects in understanding the Oracle database architecture. It covers the configurations of Oracle database instances, memory structures like SGA and PGA, and process structures such as background processes. It also explains the logical and physical database structures, including datafiles, control files, and redo log files.
|
| Topic 10 | - Automated Maintenance: This section measures the skills of Database Administrators in describing automated maintenance tasks within Oracle databases. It focuses on applying automated features to streamline routine maintenance activities.
|