Oracle Database Administration II
Follow a topic roadmap built from the published exam blueprint, with lessons, practice exercises and practice exams.
Validate your advanced theoretical and practical skills in configuring, managing, upgrading, patching, and performing backup and recovery on Oracle Databases up to version 19c.
Lessons, quizzes and hands-on practice across every Database Administration II objective, added to your roadmap. Free account.
What you'll learn
Every objective Database Administration II publishes, and what it asks you to be able to do.
- Creating CDBs and Regular PDBsConfigure and create a CDB. Create a new PDB from the CDB seed. Explore the structure of PDBs.
- Manage CDBs and PDBsManage PDB service names and connections. Manage startup, shutdown and availability of CDBs and PDBs. Change the different modes and settings of PDBs. Evaluate the impact of parameter value changes. Control CDB and PDB resource usage with the Oracle Resource Manager. Performance management in CDBs and PDBs.
- Backup and DuplicatePerform Backup and Recover CDBs and PDBs. Duplicate a Database. Duplicate an active PDB.
- Upgrading and Transporting CDBs and Regular PDBsTransport Data. Upgrade an Oracle Database.
- Manage Application PDBsClone PDBs and Application containers. Plug and unplug operations with PDBs and application containers. Comparing Local Undo Mode and Shared Undo Mode. Explain the purpose of application root and application seed. Define and create application PDBs. Install, upgrade and Patch applications. And 1 more, each a topic in the course below.
- Manage Security in Multitenant databasesManage Security in Multitenant databases. Manage PDB lockdown profiles. Audit Users in CDBs and PDBs. Manage other types of policies in application containers.
- Recovery and FlashbackRestore and Recovering Databases with RMAN. Perform CDB and PDB flashback.
- Backup Strategies and TerminologyPerform Full and Incremental Backups and Recoveries. Compress and Encrypt RMAN Backups. Use a media manager. Create multi-section backups of very large files. Create duplexed backup sets. Create archival backups. And 3 more, each a topic in the course below.
- Restore and Recovery ConceptsEmploy the best Oracle Database recovery technology for your failure situation. Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery.
- Using Flashback TechnologiesConfigure your Database to support Flashback. Perform flashback operations.
- Duplicating a DatabaseDuplicate Databases.
- Configuring and Using RMANConfigure RMAN and the Database for Recoverability. Configureand Using an RMAN recovery catalog.
- Diagnosing FailuresDetect and repair database and database block corruption. Diagnosing Database Issues.
- Performing RecoveryRestore and Recovering Databases with RMAN. Perform Non RMAN database recovery.
- Transporting DataTransport Data.
- RMAN Troubleshooting and TuningInterpret the RMAN message output. Diagnose RMAN performance issues.
- Install Grid Infrastructure and Oracle DatabaseInstall Oracle Database software. Install Grid Infrastructure for a Standalone server.
- Patching Grid Infrastructure and Oracle DatabasePatch Grid Infrastructure and Oracle Database.
- Upgrading to Oracle Grid InfrastructureUpgrade Oracle Grid Infrastructure.
- Oracle Database 18c: New FeaturesImage and RPM based Database Installation.
- Creating an Oracle Database by using DBCACreate, Delete and Configure Databases using DBCA.
- Oracle RestartConfigure and use Oracle Restart to manage components.
- Install Grid Infrastructure for a Standalone serverRapid Home Provisioning.
- Upgrade the Oracle DatabasePlan for Upgrading an Oracle Database. Upgrade an Oracle Database. Perform Post-Upgrade tasks.
- Using General Overall Database EnhancementsInstall Oracle Database software. Create, Delete and Configure Databases using DBCA. Creating CDBs and Regular PDBs. Use Miscellaneaous 19c New Features.
- Using Availability EnhancementsUse an RMAN recovery catalog. Use Flashback Database.
- Using Diagnosibility EnhancementsUse new Diagnoseability Features.
- Monitoring and Tuning Database PerformanceManaging Memory Components. Understanding The Automatic Workload Repository (AWR). Understanding The Advisory Framework. Monitoring Wait Events, Sessions, and Services. Managing Metric Thresholds and Alerts. Understanding and Using The Performance Tuning Methodology. And 2 more, each a topic in the course below.
- Tuning SQL StatementsUnderstanding The Oracle Optimizer. Understanding The SQL Tuning Process. Managing Optimizer Statistics. Using The SQL Tuning Advisor. Using The SQL Access Advisor.
The exam at a glance
- Length
- 2 hours
- Validity
- Valid until Oracle retires it
- Style
- Multiple choice
Multiple Choice. Based on 1Z0-083. Pass mark is 57%.
Sitting the exam
The part nobody publishes in a syllabus. For Database Administration II the logistics are study strategy: what you are allowed to read while the clock runs changes how you should practise, and what a second attempt costs changes when you should book.
Where you sit it
- You must take the exam in a distraction-free and quiet room.
- You are required to be the sole occupant of the room, ensure no other voices are heard, and remain completely silent throughout the duration of the test.
- Your equipment must include a personal laptop or desktop equipped with a webcam, microphone, and a dependable internet connection.
What you can look at
- Virtual backgrounds and headphones are prohibited during the test.
How it is marked
- Your exam results will become immediately visible on the screen once the exam concludes.
- You will have access to view your comprehensive score report within Oracle CertView.
Identification and proctoring
- Taking the exam necessitates a government-issued identification document.
- The first and last name on your identification must precisely match the name provided during exam registration.
Booking it
- Any required rescheduling of your exam must be completed at least 24 hours prior to your scheduled appointment time.
- You must cancel your exam at least 24 hours before the appointment time if you need to cancel it.
- Failing to cancel your exam at least 24 hours in advance runs the risk of forfeiting your exam attempt.
Read off the official exam page on 11 October 2026. Rules change without notice, so confirm anything you are about to spend money on.
What the exam covers
Oracle publishes the objectives but not a weight for each one, so treat these as equally likely to come up.
Creating CDBs and Regular PDBs
Manage CDBs and PDBs
Backup and Duplicate
Upgrading and Transporting CDBs and Regular PDBs
Manage Application PDBs
Manage Security in Multitenant databases
Recovery and Flashback
Backup Strategies and Terminology
Restore and Recovery Concepts
Using Flashback Technologies
Duplicating a Database
Configuring and Using RMAN
Diagnosing Failures
Performing Recovery
Transporting Data
RMAN Troubleshooting and Tuning
Install Grid Infrastructure and Oracle Database
Patching Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure
Oracle Database 18c: New Features
Creating an Oracle Database by using DBCA
Oracle Restart
Install Grid Infrastructure for a Standalone server
Upgrade the Oracle Database
Using General Overall Database Enhancements
Using Availability Enhancements
Using Diagnosibility Enhancements
Monitoring and Tuning Database Performance
Tuning SQL Statements
Course content
78 topics
1. Database Installation Basics
Install Oracle Database software using traditional methods
2. Install Oracle Database Software
- Install Oracle Database software
- Install Oracle Database software
3. Create, Delete and Configure Databases using DBCA
- Create, Delete and Configure Databases using DBCA
- Create, Delete and Configure Databases using DBCA
4. Grid Infrastructure Fundamentals
Understand Grid Infrastructure architecture and components for standalone servers
5. Install Grid Infrastructure for a Standalone Server
- Install Grid Infrastructure for a Standalone server
6. Configure and Use Oracle Restart
- Configure and use Oracle Restart to manage components
7. Multitenant Architecture Fundamentals
Understand CDB and PDB architecture, containers, and multitenant concepts
8. Configure and Create a CDB
- Configure and create a CDB
9. Create a New PDB from the CDB Seed
- Create a new PDB from the CDB seed
10. Explore the Structure of PDBs
- Explore the structure of PDBs
11. Manage PDB Service Names and Connections
- Manage PDB service names and connections
12. Manage Startup, Shutdown and Availability of CDBs and PDBs
- Manage startup, shutdown and availability of CDBs and PDBs
13. Change the Different Modes and Settings of PDBs
- Change the different modes and settings of PDBs
14. Evaluate the Impact of Parameter Value Changes
- Evaluate the impact of parameter value changes
15. RMAN Fundamentals
Understand RMAN architecture, channels, backup types, and basic concepts
16. Configure RMAN and the Database for Recoverability
- Configure RMAN and the Database for Recoverability
17. Recovery Catalog Concepts
Understand the purpose and architecture of RMAN recovery catalogs
18. Configure and Use an RMAN Recovery Catalog
- Configureand Using an RMAN recovery catalog
- Use an RMAN recovery catalog
19. Perform Full and Incremental Backups and Recoveries
- Perform Full and Incremental Backups and Recoveries
20. Compress and Encrypt RMAN Backups
- Compress and Encrypt RMAN Backups
21. Use a Media Manager
- Use a media manager
22. Multi-Section and Duplexed Backups
- Create multi-section backups of very large files
- Create duplexed backup sets
23. Archival and Recovery File Backups
- Create archival backups
- Backup of recovery files
24. Non-Database and ASM Metadata Backups
- Backup non database files
- Back up ASM meta data
25. Perform Backup and Recover CDBs and PDBs
- Perform Backup and Recover CDBs and PDBs
26. Recovery Technology and Failure Types
- Employ the best Oracle Database recovery technology for your failure situation
- Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
27. Restore and Recover Databases with RMAN
- Restore and Recovering Databases with RMAN
- Restore and Recovering Databases with RMAN
28. Perform Non-RMAN Database Recovery
- Perform Non RMAN database recovery
29. Flashback Technology Fundamentals
Understand flashback architecture, flashback logs, and restore points
30. Configure Your Database to Support Flashback
- Configure your Database to support Flashback
31. Perform Flashback Operations
- Perform flashback operations
- Use Flashback Database
32. Perform CDB and PDB Flashback
- Perform CDB and PDB flashback
33. Detect and Repair Database and Database Block Corruption
- Detect and repair database and database block corruption
34. Diagnose Database Issues
- Diagnosing Database Issues
35. Interpret the RMAN Message Output
- Interpret the RMAN message output
36. Diagnose RMAN Performance Issues
- Diagnose RMAN performance issues
37. Database Duplication Concepts
Understand active and backup-based duplication methods
38. Duplicate Databases
- Duplicate a Database
- Duplicate Databases
39. Duplicate an Active PDB
- Duplicate an active PDB
40. Clone PDBs and Application Containers
- Clone PDBs and Application containers
41. Plug and Unplug Operations with PDBs and Application Containers
- Plug and unplug operations with PDBs and application containers
42. Comparing Local Undo Mode and Shared Undo Mode
- Comparing Local Undo Mode and Shared Undo Mode
43. Application Container Architecture
Understand application containers, application root, and application seed concepts
44. Explain the Purpose of Application Root and Application Seed
- Explain the purpose of application root and application seed
45. Define and Create Application PDBs
- Define and create application PDBs
46. Install, Upgrade and Patch Applications
- Install, upgrade and Patch applications
47. Create and Administer Application PDBs
- Create and administer Application PDBS
48. Resource Manager Fundamentals
Understand Resource Manager architecture, plans, and consumer groups
49. Control CDB and PDB Resource Usage with the Oracle Resource Manager
- Control CDB and PDB resource usage with the Oracle Resource Manager
50. Performance Management in CDBs and PDBs
- Performance management in CDBs and PDBs
51. Manage Security in Multitenant Databases
- Manage Security in Multitenant databases
52. Manage PDB Lockdown Profiles
- Manage PDB lockdown profiles
53. Audit Users in CDBs and PDBs
- Audit Users in CDBs and PDBs
54. Manage Other Types of Policies in Application Containers
- Manage other types of policies in application containers
55. Data Transport Fundamentals
Understand data pump, transportable tablespaces, and data movement methods
56. Transport Data
- Transport Data
- Transport Data
57. Plan for Upgrading an Oracle Database
- Plan for Upgrading an Oracle Database
58. Upgrade an Oracle Database
- Upgrade an Oracle Database
- Upgrade an Oracle Database
59. Perform Post-Upgrade Tasks
- Perform Post-Upgrade tasks
60. Patch Grid Infrastructure and Oracle Database
- Patch Grid Infrastructure and Oracle Database
61. Upgrade Oracle Grid Infrastructure
- Upgrade Oracle Grid Infrastructure
62. Image and RPM Based Database Installation
- Image and RPM based Database Installation
63. Rapid Home Provisioning
- Rapid Home Provisioning
64. Use Miscellaneous 19c New Features
- Creating CDBs and Regular PDBs
- Use Miscellaneaous 19c New Features
65. Use New Diagnosability Features
- Use new Diagnoseability Features
66. Managing Memory Components
- Managing Memory Components
67. Understanding The Automatic Workload Repository (AWR)
- Understanding The Automatic Workload Repository (AWR)
68. Understanding The Advisory Framework
- Understanding The Advisory Framework
69. Monitoring Wait Events, Sessions, and Services
- Monitoring Wait Events, Sessions, and Services
70. Managing Metric Thresholds and Alerts
- Managing Metric Thresholds and Alerts
71. Understanding and Using The Performance Tuning Methodology
- Understanding and Using The Performance Tuning Methodology
72. Performing Performance Planning
- Performing Performance Planning
73. Understanding The Automatic Database Diagnostic Monitor (ADDM)
- Understanding The Automatic Database Diagnostic Monitor (ADDM)
74. Understanding The Oracle Optimizer
- Understanding The Oracle Optimizer
75. Understanding The SQL Tuning Process
- Understanding The SQL Tuning Process
76. Managing Optimizer Statistics
- Managing Optimizer Statistics
77. Using The SQL Tuning Advisor
- Using The SQL Tuning Advisor
78. Using The SQL Access Advisor
- Using The SQL Access Advisor
What to know before you start
- Database architecture
- Managing database instances
- Managing users, roles, and privileges
- Managing storage
- SQL programming skills
Other certifications
Frequently asked questions
How much does the Database Administration II exam cost?
Fee on Oracle's site, and worth checking there before you book.
How long is the Database Administration II exam?
2 hours. Multiple Choice.
How many questions are on the Database Administration II exam?
Multiple Choice. The sitting is 2 hours long. Check the current count with Oracle before you book.
How long is Database Administration II valid?
It has no fixed term: it stays active until Oracle retires it.
Is the Database Administration II exam hands-on?
No. It is a written exam, so the skill it tests is recognising the right design or command rather than executing it under time pressure.
What is on the Database Administration II exam?
29 objectives: Creating CDBs and Regular PDBs, Manage CDBs and PDBs, Backup and Duplicate, Upgrading and Transporting CDBs and Regular PDBs, Manage Application PDBs, Manage Security in Multitenant databases, Recovery and Flashback, Backup Strategies and Terminology, Restore and Recovery Concepts, Using Flashback Technologies, Duplicating a Database, Configuring and Using RMAN, Diagnosing Failures, Performing Recovery, Transporting Data, RMAN Troubleshooting and Tuning, Install Grid Infrastructure and Oracle Database, Patching Grid Infrastructure and Oracle Database, Upgrading to Oracle Grid Infrastructure, Oracle Database 18c: New Features, Creating an Oracle Database by using DBCA, Oracle Restart, Install Grid Infrastructure for a Standalone server, Upgrade the Oracle Database, Using General Overall Database Enhancements, Using Availability Enhancements, Using Diagnosibility Enhancements, Monitoring and Tuning Database Performance, Tuning SQL Statements. Oracle does not publish a weight per objective.
What should I know before starting Database Administration II?
Database architecture. Managing database instances. Managing users, roles, and privileges. Managing storage. SQL programming skills.
Exam details from Oracle, checked August 2026. Always confirm on their page before booking.
What learners say about Acelro
About Acelro rather than the Database Administration II exam: what learners made of the gap analysis, the roadmap and the projects.
“The roadmap makes me focus on a learning curve, no matter the length.”
“Acelro has been really great for me, an inspiring experience. I've gained a lot of confidence doing projects I thought were rocket science.”
“The gap analysis maps your actual skills against what the current job market is asking for. Nobody else made it that clear where I stood.”