| Topic | Details |
| Topic 1 | - 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 2 | - 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 3 | - Describe Managing Database Instances: This section tests the knowledge of Database Administrators in performing essential tasks for managing database instances. It includes starting and shutting down databases, utilizing dynamic performance views, managing initialization parameter files, and using the Automatic Diagnostic Repository (ADR) for troubleshooting.
|
| Topic 4 | - 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.
|
| Topic 5 | - Introduction to Auditing: This domain tests the abilities of Compliance Specialists in implementing database auditing practices. It includes creating, modifying, and maintaining auditing policies while applying value-based auditing techniques like Fine-Grained Auditing (FGA).
|
| Topic 6 | - 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 7 | - Employ Oracle-Supplied Database Tools: This section evaluates the abilities of Database Engineers and Support Specialists in identifying and using Oracle-supplied tools for managing databases. It focuses on leveraging tools to monitor, troubleshoot, and optimize database performance effectively.
|
| Topic 8 | - 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 9 | - 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.
|