| Section | Weight | Objectives |
| Topic 1: Creating an Oracle Database | 7% | - Using Database Configuration Assistant (DBCA) - Manual database creation
|
| Topic 2: Moving Data | 5% | - SQL*Loader - Data Pump Export/Import
|
| Topic 3: Performing Database Recovery | 5% | - Recovery concepts - Control file, redo log, and data file recovery - Data Recovery Advisor
|
| Topic 4: Managing Database Storage Structures | 10% | - ASM instance management - Space management - Tablespaces and data files
|
| Topic 5: Managing Undo Data | 6% | - Undo configuration - Guaranteed undo retention
|
| Topic 6: Managing Schema Objects | 8% | - Temporary and undo segments - Indexes and views - Tables and constraints
|
| Topic 7: Configuring the Oracle Network Environment | 6% | - Listener configuration - Oracle Net Services - Shared server architecture
|
| Topic 8: Performing Database Backups | 7% | - ARCHIVELOG mode - Consistent and inconsistent backups - Backup concepts - Flash Recovery Area
|
| Topic 9: Exploring the Oracle Database Architecture | 8% | - Storage structures - Memory structures - Single-instance architecture - Process structures
|
| Topic 10: Managing Data and Concurrency | 7% | - Lock management - PL/SQL objects - DML operations and transactions
|
| Topic 11: Administering User Security | 9% | - User accounts and authentication - Privileges and roles - Profiles and resource limits
|
| Topic 12: Preparing the Database Environment | 7% | - Installation planning - Administrative tools - Data dictionary and dynamic views
|
| Topic 13: Managing the Oracle Instance | 10% | - Startup and shutdown stages - Initialization parameters - Alert log and trace files
|