ORACLE-AI-DATABASE-ADMIN-PROFESSIONAL: AI Database Administration Professional

Expert Oracle Oracle
Browse certifications

Exam Resources

Official learning paths, exam details, skills measured, and community resources to supplement your study.

About the ORACLE-AI-DATABASE-ADMIN-PROFESSIONAL Exam

Master the Oracle AI Database Administration Professional exam (1Z0-183) - multitenant CDB and PDB administration, RMAN backup and recovery, flashback, performance tuning with AWR, ASH and ADDM, Grid Infrastructure installation, patching and upgrades, and the new Oracle AI Database 26ai features including AI Vector Search, True Cache, Lock-Free Reservations and blockchain tables.

The complete practice exam for the Oracle AI Database Administration Professional certification (exam 1Z0-183, validated against Oracle AI Database 26ai). A professional-level certification for working database administrators, infrastructure engineers, and platform teams who install, operate, tune, protect, and upgrade a self-managed Oracle database estate on-premises, in the cloud, or hybrid. Covers Managing Multitenant Architecture (creating CDBs with DBCA, creating regular and application PDBs, cloning, relocating, unplugging and plugging, refreshable clones and the snapshot carousel, common versus local users, lockdown profiles, securing multitenant databases, and upgrading and transporting PDBs); Performing Backup and Recovery (configuring and using RMAN, backup sets versus image copies, full versus level 0 and differential versus cumulative incremental strategies, the fast recovery area and the recovery catalog, diagnosing failures with the Data Recovery Advisor, complete and point-in-time recovery, the flashback technologies, cross-platform transport, database duplication, and tuning and troubleshooting RMAN); Managing and Tuning Performance (basic tuning and diagnostics, metrics, alerts and baselines, AWR, ASH and ADDM, application monitoring, SQL statement processing and optimization, reducing the cost of SQL operations, Real Application Testing with SQL Performance Analyzer and Database Replay, instance tuning, and the In-Memory Column Store); Deploying, Patching and Upgrades (installing Grid Infrastructure and Oracle Database, creating databases with DBCA, applying patches with OPatch and datapatch, configuring Oracle Restart, and upgrading Grid Infrastructure and the database with AutoUpgrade); and New Features in Oracle AI Database (AI Vector Search with HNSW and IVF vector indexes, OLTP and core database enhancements, availability features such as True Cache, manageability and performance improvements, and database security enhancements).

Who Should Take This Exam?

The ORACLE-AI-DATABASE-ADMIN-PROFESSIONAL is designed for experienced professionals seeking advanced validation. 2+ years of hands-on experience recommended.

Prerequisites: None required to sit the exam. Oracle recommends hands-on experience administering Oracle Database, including multitenant, RMAN, and performance tuning.

Typical study time: 8-12 weeks of intensive study

Exam Quick Facts

DetailValue
Exam CodeORACLE-AI-DATABASE-ADMIN-PROFESSIONAL
TitleAI Database Administration Professional
Duration120 minutes
Questions65
Pass Score60%
Cost$245 USD (verify at Oracle University registration)
ProviderOracle University / Oracle MyLearn (online proctored certification exam)
ValidityOracle Database certifications do not expire (verify the current Oracle Recertification policy)
PrerequisitesNone required to sit the exam. Oracle recommends hands-on experience administering Oracle Database, including multitenant, RMAN, and performance tuning.
Question TypesMultiple choice
Official PageView on Oracle →

Exam Domains & Weights

The ORACLE-AI-DATABASE-ADMIN-PROFESSIONAL exam covers 5 domains. Focus your study time based on the weights below — higher-weighted domains have more exam questions.

DomainWeightPractice Qs
Managing Multitenant Architecture20%50
Performing Backup and Recovery20%50
Managing and Tuning Performance25%62
Deploying, Patching and Upgrades15%38
New Feature in Oracle AI Database20%50
Total100%250

💡 Study tip: Managing and Tuning Performance carries the most weight (25%) — start there. Deploying, Patching and Upgrades has the least (15%), but don’t skip it — exam questions can come from any domain.

Practice Exam — 250 Questions

Prepare for the ORACLE-AI-DATABASE-ADMIN-PROFESSIONAL with our 250-question practice exam covering all 5 exam domains. Every question includes detailed explanations and maps to official exam objectives.

What you get:

  • ✅ Exam simulation mode with timer
  • ✅ Spaced repetition for weak areas
  • ✅ Detailed explanations for every question
  • ✅ Progress tracking across domains
  • ✅ 20 free questions — no account needed

Oracle Certification Path

Start with OCI Foundations, then Architect Associate, and advance to Architect Professional and specialty tracks (Developer, Security, Networking, Data Science, Generative AI).

If you’re studying for the ORACLE-AI-DATABASE-ADMIN-PROFESSIONAL, you might also be interested in these Oracle certifications:

Study Tips

  1. Start with the heaviest domain — focus your time where the exam focuses its questions
  2. Use our practice exam — try the 20 free questions first to gauge your readiness
  3. Review explanations — don’t just check if you got it right; read why each answer is correct
  4. Simulate exam conditions — use the timed exam mode to practice under pressure
  5. Check the official page — official exam details always have the latest objectives
20 Free Questions Practice Exam $9 →