Oracle Autonomous AI Database Professional

Study plan

Oracle logo

How to Pass the Oracle Autonomous AI Database Professional Exam

1Z0-931-26

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. 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. 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. 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. 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. 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. 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. 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. 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. 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.

Step 1

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.

Step 2

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.

Step 3

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.