Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Oracle Autonomous Database Professional Practice Questions

Pass your Oracle AI Autonomous Database 2025 Professional (1Z0-931-25) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

When provisioning an Autonomous Database Serverless instance, which parameter determines the workload optimization (transaction vs analytics)?

A
B
C
D
to track
Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice Questions1 blog

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions

More From This Family

Videos and articles for deeper review.

ArticleOracle SQL 1Z0-071 Exam Guide 2026: Official Facts, Topic Traps, and Practice Plan12 min read
2026 Statistics

Key Facts: Oracle Autonomous Database Professional Exam

50

Exam Questions

Oracle University

90 min

Exam Duration

Oracle University

68%

Passing Score

Oracle University

$245

Exam Fee

Oracle University

7 domains

Exam Topic Areas

Oracle University

24 months

Credential Validity

Oracle certification guidelines

Oracle University lists the Oracle AI Autonomous Database 2025 Professional exam 1Z0-931-25 as a multiple-choice exam with roughly 50 questions, a 90-minute time limit, a 68% passing score, and a $245 fee. The largest domains each carry 20%: Autonomous Database Shared, Managing and Maintaining Autonomous Database, and Developing on Autonomous Database. Getting Started, Autonomous Database Dedicated, and Autonomous Database Tools each carry 11%, and Migrating to Autonomous Database carries 7%. The exam is validated against Oracle Cloud Infrastructure 2025 and Autonomous Database 23ai features such as Select AI and AI Vector Search.

Sample Oracle Autonomous Database Professional Practice Questions

Try these sample questions to test your Oracle Autonomous Database Professional exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1What is the primary characteristic that makes Oracle Autonomous Database 'autonomous'?
A.It eliminates the need for any SQL queries
B.It automates provisioning, patching, tuning, backups, and security using machine learning
C.It runs only on dedicated hardware that customers manage
D.It requires manual DBA intervention for every patch
Explanation: Autonomous Database uses machine learning to automate routine administrative tasks such as provisioning, patching, performance tuning, backups, and security operations. This self-driving, self-securing, and self-repairing design reduces the manual DBA burden. The goal is to minimize human error and downtime.
2Which workload type is Autonomous Transaction Processing (ATP) optimized for?
A.Data warehousing and large analytic scans
B.High-concurrency transactional and mixed workloads
C.Static archival storage only
D.Batch-only reporting with no online users
Explanation: Autonomous Transaction Processing (ATP) is tuned for transactional and mixed workloads that involve high concurrency, frequent inserts/updates, and short-running queries. It defaults to row-format storage and indexing strategies suited to OLTP. Autonomous Data Warehouse (ADW) is the alternative for analytics.
3Which workload type optimizes data using columnar formats and is designed for analytics?
A.Autonomous Transaction Processing (ATP)
B.Autonomous Data Warehouse (ADW)
C.Autonomous JSON Database (AJD)
D.APEX Application Development
Explanation: Autonomous Data Warehouse (ADW) is optimized for data warehousing and analytic workloads, using columnar storage formats and parallel query to accelerate large scans and aggregations. It defaults to avoiding indexes in favor of in-memory and columnar techniques. ATP, by contrast, targets transactional workloads.
4What distinguishes Autonomous JSON Database (AJD) from other Autonomous Database workload types?
A.It is optimized for document-centric development with the SODA APIs and limits non-JSON data
B.It can only store relational tables
C.It is the same as Autonomous Data Warehouse with a different name
D.It does not support SQL at all
Explanation: Autonomous JSON Database (AJD) is optimized for JSON-centric application development using Simple Oracle Document Access (SODA) and document APIs. It has a lower price point but limits the amount of non-JSON data you can store (typically 20 GB of non-JSON). You can upgrade AJD to ATP if you need full relational capability.
5Which two deployment options does Autonomous Database offer?
A.On-premises only and edge only
B.Serverless (shared) and Dedicated infrastructure
C.Mobile and desktop
D.Read-only and write-only
Explanation: Autonomous Database is offered in two deployment models: Serverless (also called shared), where Oracle manages everything on shared Exadata infrastructure, and Dedicated, where you provision Autonomous Database on isolated Exadata infrastructure within your tenancy. Dedicated gives more isolation and control over patching and policies.
6On which Oracle technology is Autonomous Database built?
A.Oracle Exadata infrastructure running Oracle Database
B.A custom NoSQL engine unrelated to Oracle Database
C.MySQL Community Edition
D.A proprietary key-value store
Explanation: Autonomous Database runs Oracle Database on Oracle Exadata infrastructure in OCI. Exadata provides the high-performance compute, storage, and Smart Scan capabilities that underpin the service. This is why Autonomous Database inherits full Oracle Database features and SQL compatibility.
7What does the 'Bring Your Own License' (BYOL) option provide for Autonomous Database?
A.Free unlimited storage
B.Discounted compute pricing by applying existing Oracle Database licenses
C.A second free database instance
D.Automatic upgrade to Dedicated infrastructure
Explanation: Bring Your Own License (BYOL) lets customers who already own eligible Oracle Database licenses apply them to Autonomous Database, lowering the compute (OCPU/ECPU) cost compared to License Included pricing. License Included bundles the database license into the hourly rate. The storage cost is unaffected by the license model.
8Which compute billing model does Autonomous Database Serverless use by default for newer instances?
A.OCPU only with no scaling
B.ECPU, an elastic compute model billed per ECPU
C.Per-query billing
D.Per-table billing
Explanation: Autonomous Database Serverless uses the ECPU (Elastic Compute) billing model, which decouples compute from storage and bills based on ECPUs consumed. ECPU replaced the older OCPU model for new provisioning. This model supports finer-grained elastic scaling.
9Which statement about the Always Free Autonomous Database is correct?
A.It provides unlimited OCPUs and storage
B.It provides a limited, no-cost Autonomous Database with capped compute and storage
C.It requires a paid subscription after one hour
D.It only supports ADW, never ATP
Explanation: Always Free Autonomous Database offers a no-cost instance with capped resources (a small fixed amount of compute and storage, e.g., around 1 OCPU and 20 GB). It is intended for learning, development, and small workloads. Both ATP and ADW workload types are available as Always Free.
10A team wants a converged database that handles relational, JSON, spatial, graph, and vector data in a single Autonomous Database. Is this possible?
A.No, each data type requires a separate database product
B.Yes, Autonomous Database is a converged database supporting multiple data models in one engine
C.Only if they purchase three separate add-ons
D.Only on Dedicated infrastructure
Explanation: Autonomous Database is a converged database, meaning a single instance natively supports relational, JSON, spatial, graph, text, and vector data without bolting on separate engines. This reduces data fragmentation and simplifies development. The converged model is a key value proposition for the platform.

About the Oracle Autonomous Database Professional Exam

Oracle's AI Autonomous Database 2025 Professional exam (1Z0-931-25) validates the skills to deploy, manage, secure, and develop on Oracle Autonomous Database in OCI. The blueprint spans the Autonomous Database architecture and offerings, the Serverless and Dedicated deployment models, ongoing management and maintenance, the built-in development tools, AI-driven development with Select AI and AI Vector Search, and migration strategies using Data Pump and Zero Downtime Migration.

Questions

50 scored questions

Time Limit

90 minutes

Passing Score

68%

Exam Fee

$245 (Oracle University)

Oracle Autonomous Database Professional Exam Content Outline

11%

Getting Started with Autonomous Database

Review the Autonomous Database architecture, converged-database design on Exadata, the ATP, ADW, AJD, and APEX offerings, ECPU billing, Always Free, and BYOL versus License Included options.

20%

Autonomous Database Shared

Master provisioning, online compute and storage auto scaling, full/metadata/refreshable clones, Elastic Resource Pools, user management, service names, and Autonomous Data Guard on the serverless model.

11%

Autonomous Database Dedicated

Understand Autonomous Exadata Infrastructure, VM clusters, Autonomous Container Databases, Exadata Cloud@Customer, fleet administration, and customizable maintenance scheduling.

20%

Managing and Maintaining Autonomous Database

Cover REST API automation, OCI Monitoring and Notifications, Performance Hub, auto-indexing, Data Safe, TDE and customer-managed keys, backups, point-in-time restore, and disaster recovery.

11%

Autonomous Database Tools

Know Database Actions (SQL Developer Web), APEX, Oracle Machine Learning, ORDS, the Data Load wizard, DBMS_CLOUD, and Data Transforms for loading and shaping data.

20%

Developing on Autonomous Database

Build with Select AI natural-language queries, AI Vector Search and RAG, JSON and SODA, JSON-relational duality, Oracle Text, Spatial, Graph, PL/SQL, MLE JavaScript, and Object Storage integration.

7%

Migrating to Autonomous Database

Plan migrations with readiness checks, use Oracle Data Pump staged in Object Storage, and achieve minimal downtime with Zero Downtime Migration and GoldenGate replication.

How to Pass the Oracle Autonomous Database Professional Exam

What You Need to Know

  • Passing score: 68%
  • Exam length: 50 questions
  • Time limit: 90 minutes
  • Exam fee: $245

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Oracle Autonomous Database Professional Study Tips from Top Performers

1Prioritize the three 20% domains (Autonomous Database Shared, Managing and Maintaining, and Developing) because together they make up about 60% of the exam.
2Memorize the consumer-group service names: HIGH, MEDIUM, and LOW for ADW priorities and TP and TPURGENT for ATP transactional priorities.
3Be able to distinguish full clones, metadata clones, and refreshable clones, and when to use each for dev/test, reporting, or offload.
4Understand auto scaling: a database can burst to three times its base ECPU and storage, and you pay only for actual usage above the base.
5Practice the AI development stack hands-on: configure a Select AI profile with DBMS_CLOUD_AI and run AI Vector Search similarity queries on Oracle Database 23ai.
6Know the migration path: export with Data Pump, stage dump files in Object Storage with a DBMS_CLOUD credential, and use Zero Downtime Migration or GoldenGate for minimal downtime.

Frequently Asked Questions

What are the official exam facts for 1Z0-931-25?

Oracle University lists the Oracle AI Autonomous Database 2025 Professional exam (1Z0-931-25) as a multiple-choice exam with roughly 50 questions, a 90-minute time limit, a 68% passing score, and a $245 fee. It is validated against Oracle Cloud Infrastructure 2025.

Which domains are weighted most heavily on the exam?

Three domains each carry 20%: Autonomous Database Shared, Managing and Maintaining Autonomous Database, and Developing on Autonomous Database. Getting Started, Autonomous Database Dedicated, and Autonomous Database Tools each carry 11%, and Migrating to Autonomous Database carries 7%.

What is the difference between ATP, ADW, and AJD?

Autonomous Transaction Processing (ATP) is optimized for transactional and mixed workloads, Autonomous Data Warehouse (ADW) is optimized for analytics with columnar storage, and Autonomous JSON Database (AJD) is optimized for JSON document development. All run the same converged Oracle Database engine.

What is the difference between Serverless and Dedicated deployments?

Serverless (shared) runs on Oracle-managed shared Exadata infrastructure with fast, elastic provisioning. Dedicated runs on isolated Autonomous Exadata Infrastructure in your tenancy, giving more control over isolation, maintenance scheduling, and governance.

What AI features does the exam cover?

The exam covers Select AI, which converts natural-language prompts to SQL using an LLM via DBMS_CLOUD_AI profiles, and AI Vector Search, which adds the VECTOR data type and similarity search for semantic search and retrieval-augmented generation on Oracle Database 23ai.

How long is the certification valid after you pass?

Oracle's certification program guidelines state that Oracle Cloud Infrastructure certifications are valid for 24 months from the date the credential is earned, after which recertification is required to remain current.