Exam Domains
1.0 Creating CDBs and Regular PDBs
Weight not published
- 1.1Configure and create a CDB
- 1.2Create a new PDB from the CDB seed
- 1.3Explore the structure of PDBs
2.0 Manage CDBs and PDBs
Weight not published
- 2.1Manage PDB service names and connections
- 2.2Manage startup, shutdown and availability of CDBs and PDBs
- 2.3Change the different modes and settings of PDBs
- 2.4Evaluate the impact of parameter value changes
- 2.5Performance management in CDBs and PDBs
- 2.6Control CDB and PDB resource usage with the Oracle Resource Manager
3.0 Backup and Duplicate
Weight not published
- 3.1Perform Backup and Recover CDBs and PDBs
- 3.2Duplicate an active PDB
- 3.3Duplicate a Database
4.0 Upgrading and Transporting CDBs and Regular PDBs
Weight not published
- 4.1Upgrade an Oracle Database
- 4.2Transport Data
5.0 Manage Application PDBs
Weight not published
- 5.1Explain the purpose of application root and application seed
- 5.2Define and create application PDBs
- 5.3Install, upgrade and Patch applications
- 5.4Create and administer Application PDBS
- 5.5Clone PDBs and Application containers
- 5.6Plug and unplug operations with PDBs and application containers
6.0 Comparing Local Undo Mode and Shared Undo Mode
Weight not published
- 6.1Manage Security in Multitenant databases
- 6.2Manage PDB lockdown profiles
- 6.3Audit Users in CDBs and PDBs
- 6.4Manage other types of policies in application containers
7.0 Recovery and Flashback
Weight not published
- 7.1Restore and Recovering Databases with RMAN
- 7.2Perform CDB and PDB flashback
8.0 Backup Strategies and Terminology
Weight not published
- 8.1Perform Full and Incremental Backups and Recoveries
- 8.2Compress and Encrypt RMAN Backups
- 8.3Use a media manager
- 8.4Create multi-section backups of very large files
- 8.5Create duplexed backup sets
- 8.6Create archival backups
- 8.7Backup of recovery files
- 8.8Backup non database files
- 8.9Back up ASM meta data
9.0 Restore and Recovery Concepts
Weight not published
- 9.1Employ the best Oracle Database recovery technology for your failure situation
- 9.2Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
10.0 Using Flashback Technologies
Weight not published
- 10.1Configure your Database to support Flashback
- 10.2Perform flashback operations
11.0 Duplicating a Database
Weight not published
12.0 Configuring and Using RMAN
Weight not published
- 12.1Configure RMAN and the Database for Recoverability
- 12.2Configure and Using an RMAN recovery catalog
13.0 Diagnosing Failures
Weight not published
- 13.1Detect and repair database and database block corruption
- 13.2Diagnosing Database Issues
14.0 Performing Recovery
Weight not published
- 14.1Restore and Recovering Databases with RMAN
- 14.2Perform Non RMAN database recovery
15.0 Transporting Data
Weight not published
16.0 RMAN Troubleshooting and Tuning
Weight not published
- 16.1Interpret the RMAN message output
- 16.2Diagnose RMAN performance issues
17.0 Install Grid Infrastructure and Oracle Database
Weight not published
- 17.1Install Grid Infrastructure for a Standalone server
- 17.2Install Oracle Database software
18.0 Patching Grid Infrastructure and Oracle Database
Weight not published
- 18.1Patch Grid Infrastructure and Oracle Database
19.0 Upgrading to Oracle Grid Infrastructure
Weight not published
- 19.1Upgrade Oracle Grid Infrastructure
20.0 Oracle Database 18c: New Features
Weight not published
- 20.1Image and RPM based Database Installation
21.0 Creating an Oracle Database by using DBCA
Weight not published
- 21.1Create, Delete and Configure Databases using DBCA
22.0 Oracle Restart
Weight not published
- 22.1Configure and use Oracle Restart to manage components
23.0 Upgrade the Oracle Database
Weight not published
- 23.1Plan for Upgrading an Oracle Database
- 23.2Upgrade an Oracle Database
- 23.3Perform Post-Upgrade tasks
24.0 Install Grid Infrastructure for a Standalone server
Weight not published
- 24.1Rapid Home Provisioning
25.0 Using General Overall Database Enhancements
Weight not published
- 25.1Install Oracle Database software
- 25.2Create, Delete and Configure Databases using DBCA
- 25.3Creating CDBs and Regular PDBs
- 25.4Use Miscellaneaous 19c New Features
26.0 Using Availability Enhancements
Weight not published
- 26.1Use an RMAN recovery catalog
- 26.2Use Flashback Database
27.0 Using Diagnosibility Enhancements
Weight not published
- 27.1Use new Diagnoseability Features
28.0 Monitoring and Tuning Database Performance
Weight not published
- 28.1Managing Memory Components
- 28.2Understanding The Automatic Workload Repository (AWR)
- 28.3Understanding The Advisory Framework
- 28.4Monitoring Wait Events, Sessions, and Services
- 28.5Managing Metric Thresholds and Alerts
- 28.6Understanding and Using The Performance Tuning Methodology
- 28.7Performing Performance Planning
- 28.8Understanding The Automatic Database Diagnostic Monitor (ADDM)
29.0 Tuning SQL Statements
Weight not published
- 29.1Understanding The Oracle Optimizer
- 29.2Using The SQL Tuning Advisor
- 29.3Managing Optimizer Statistics
- 29.4Using The SQL Access Advisor
- 29.5Understanding The SQL Tuning Process
Exam Details
Question TypesMultiple Choice, Multiple Select
FormatLinear
Online ProctoringAvailable
ID RequirementsOne valid government-issued photo ID with full name. Name must match Pearson VUE registration exactly.
RenewalNot required -- Oracle certifications are version-specific. When Oracle releases a new database/platform version, a new exam version is typically released. Previous certifications remain valid as earned.
Retake Policy14-day waiting period after failed attempt. Maximum 3 attempts per exam in a 12-month period. Full exam fee required for each retake.
LanguagesEnglish, Brazilian Portuguese, Simplified Chinese, Japanese, Korean, Spanish