
Study plan
How to Pass the Oracle Autonomous AI Database Professional Exam
A study plan for the Oracle Autonomous AI Database Professional certification exam, built from the official domain weights instead of a generic template. Start with Fundamentals and Dedicated Deployments (18% each). Master the four-level ADB-D hierarchy. Understand Select AI actions and AI Vector Search. Practice with Database Actions and ORDS.
- 9 domains
- 50 questions
- 90 min
- 68% to pass
Study in weight order, not topic order
The plan below follows the official blueprint weights, so the order of study is the order that returns the most points.
- 1
Implementing Autonomous Database Fundamentals
18%- Self-driving, self-securing, self-repairing architecture
- ATP vs ADW workload types
- ECPU vs OCPU compute
- Secure public and private endpoints with ACLs
- +1 more topics in the blueprint
9 practice questions tagged to this domain.
- 2
Implementing Autonomous Database Dedicated Deployments
18%- Exadata Infrastructure
- Autonomous Exadata VM Cluster
- Autonomous Container Database hierarchy
- Exadata Cloud@Customer
- +1 more topics in the blueprint
9 practice questions tagged to this domain.
- 3
Managing, Monitoring, and Optimizing Performance
16%- Performance Hub with AWR, ASH, SQL Monitor
- Automatic Indexing
- Consumer-group services
- Oracle Data Safe
- +2 more topics in the blueprint
8 practice questions tagged to this domain.
- 4
Designing Unified Data Management and AI Analytics
14%- Converged database
- JSON Relational Duality Views
- AI Vector Search with HNSW and IVF indexes
- VECTOR_DISTANCE
7 practice questions tagged to this domain.
- 5
Applying Autonomous Database Serverless Architectures
12%- Shared-Exadata model
- Full and refreshable clones
- Autonomous Data Guard
- Automatic backups and Point-in-Time Restore
6 practice questions tagged to this domain.
- 6
Applying Select AI Capabilities
8%- SELECT AI runsql, showsql, narrate, explainsql, chat actions
- AI profiles
- Supported LLM providers
4 practice questions tagged to this domain.
- 7
Understanding Migration and Data Integration
6%- Pre-migration Advisor
- Data Pump with DBMS_CLOUD
- Zero Downtime Migration
- GoldenGate
3 practice questions tagged to this domain.
- 8
Implementing MCP Server Integration
4%- Exposing database as Model Context Protocol server
- ORDS-based MCP for AI agents
2 practice questions tagged to this domain.
- 9
Utilizing and Analyzing Autonomous Database Tools
4%- Database Actions
- Oracle APEX
- Oracle Machine Learning
- Data Studio
- +1 more topics in the blueprint
2 practice questions tagged to this domain.
Three phases, in order
Most failures are process failures, not knowledge failures.
Phase 1 — Learn the high-weight domains
Start where the points are. The first domains on this plan carry the most weight, so a gap there costs the most. Cover the objectives, then close each topic with practice questions you actually get wrong.
Phase 2 — Close the mid-weight domains
The middle of the blueprint is where most candidates plateau. These domains are worth less per topic than the first phase, but they add up fast, and they are the usual difference between a near miss and a clear pass.
Phase 3 — Timed full mocks
Stop reading new material at this point. Run full-length exams under the real time limit and the real format, and use the per-domain breakdown to find which domain is still costing you the pass.
Where we put the emphasis
Practical implementation of Autonomous Database Serverless and Dedicated deployments, AI-powered features (Select AI, MCP, Vector Search), and migration strategies.
The order matters less than the loop. Every domain you finish should end with questions you got wrong, because the mistake is the only thing you actually needed to study. On the Oracle Autonomous AI Database Professional that loop is worth 8% of the exam in the first block alone.
More about the Oracle Autonomous AI Database Professional exam
Explore the rest of this page series: format, cost, difficulty, requirements and how to prepare.
Related certifications
Explore other certifications in the same category and see how they stack up.
Frequently asked questions
Everything you need to know about the Oracle Autonomous AI Database Professional exam.
