Oracle DBA Certification: Exams, Format, Passing Score — Certsqill
7-day money-back guarantee — full refund within 7 days of purchase if you've completed under 20% of the questions. See pricing →
Certifications Tools Flashcards Career Paths Exam Guides Blog Pricing For Teams About
Home›Certifications›Oracle›1Z0-183
Oracleintermediate✓ Updated 2026

Oracle DBA certification: exams, format and passing score

Coming soonget notified at launch

4.6/5 873 verified reviews

Oracle currently lists two routes to a professional Oracle DBA certification: the newer Oracle AI Database Administration Professional exam, 1Z0-183, which Oracle announced at 65 questions in 120 minutes with a 60% passing score, and the Oracle Database Administration 2019 Certified Professional, earned by passing both 1Z0-082 and 1Z0-083.

Coming soon
Newest professional exam
1Z0-183 Oracle AI Database Administration Professional (announced as Oracle Database 23ai Administration Professional)Oracle certification catalog and Oracle University announcement, checked 8 October 2026
1Z0-183 questions
65Oracle University announcement of April 2025, checked 8 October 2026
1Z0-183 duration
120 minutesOracle University announcement of April 2025, checked 8 October 2026
1Z0-183 passing score
60%Oracle University announcement of April 2025, checked 8 October 2026
Associate step
1Z0-182 Oracle AI Database Administration Associate — recommended as preparationOracle certification catalog and Oracle University announcement, checked 8 October 2026
19c route
Oracle Database Administration 2019 Certified Professional: pass 1Z0-082 and 1Z0-083Oracle 2019 certification FAQ, checked 8 October 2026
Training requirement
Not required for the 2019 route; Oracle strongly recommends itOracle 2019 certification FAQ, checked 8 October 2026
Exam price
Not stated on the Oracle pages we could checkOracle states the price is provided in the currency offered by Oracle University, checked 8 October 2026
Recertification
Oracle says certain Database credentials require periodic recertification, without naming whichOracle Certification Program Guidelines, checked 8 October 2026

Get notified when the Oracle DBA question bank launches →

Know if you're ready for Oracle AI Database Administration Professional 1Z0-183 — before you book.

Certsqill measures your 1Z0-183 readiness across every official exam domain — one 0–100 score built only from first-try answers and kept deliberately conservative, so a high number has to be earned. It tells you whether to book, keep studying, or sit.

Coming soon
● REAL PRODUCT · NOT A MOCKUPCertsqill dashboard: an exam readiness score of 88 out of 100 for AWS Certified Cloud Practitioner, labelled ‘On track’, projecting 85–100 on exam day with the exam ten days away.
A real Certsqill account mid-preparation, shown on AWS Certified Cloud Practitioner. Representative state, not a specific customer.
Coming soon
Practice questions
The difference

Why people switch to Certsqill

The old way
✕Endless 1Z0-183 question banks
✕No idea if you're actually ready
✕Generic explanations
✕Monthly subscriptions
Certsqill
✓Know your readiness
✓Find weak domains instantly
✓AI explains every mistake
✓One payment. Lifetime access.

Everything you need to walk in ready

Know where you stand, understand every mistake, and study in your language — one payment, no subscription.

KNOW WHEN YOU'RE READY

Your Oracle AI Database Administration Professional 1Z0-183 Readiness Score, not a guess

One conservative number from your first-try answers across every exam domain tells you whether to book the exam or keep studying.

Certsqill domain readiness panel: each exam domain listed with its accuracy and a Ready or Needs work label.
Check your Oracle AI Database Administration Professional 1Z0-183 readiness — free →
UNDERSTAND EVERY MISTAKE

Understand every Oracle AI Database Administration Professional 1Z0-183 mistake

When you miss a question, it explains why — using your own answer history to catch the patterns you keep repeating. Included, no subscription.

An answered Certsqill question showing why the correct option is right, why each other option is wrong, and a “Common trap” note.
STUDY IN YOUR LANGUAGE

Explanations in your language, questions stay exam-accurate

Get every explanation in your language while the questions stay in exam-accurate English. Technical terms stay in English — the way the exam writes them.

The Certsqill AI tutor explaining a wrong answer, with an 'Explain in' language selector for reading explanations in eleven languages.
Explanations available in your language — questions stay in exam-accurate English.EnglishDeutschEspañolPortuguêsFrançaisItalianoPolskiNederlandsTürkçe简体中文العربية
What's Included

Everything you need to pass

Practice Questions — coming soon
Mapped to the official Oracle AI Database Administration Professional 1Z0-183 exam blueprint.
Expert-Developed Explanations
Instant, in-context explanations for any question or concept.
AI Study Tutor
Explains why you got a question wrong, in context — expert-developed questions, an AI tutor that helps you understand them. No subscription.
Spaced-Repetition Review
We resurface the questions you're about to forget, right when you need them.
Exam Readiness Score
A 0–100 score by domain that tells you when you're ready — not just hopeful.
Study Plan to Your Exam Date
Set your test date and we pace your prep so you peak on the day.
Domain Coverage Analytics
See exactly where you're strong and where to focus.
Lifetime Updates
When Oracle updates 1Z0-183, so does Certsqill. No re-purchase needed.
1Z0-183
Oracle AI Database Administration Professional 1Z0-183
Coming soon
questions
$49one-time
7-day money-back guarantee · lifetime access
Coming soon
7-day money-back guarantee — full refund within 7 days of purchase if you've completed under 20% of the questions.
Secure checkout · encrypted payments by Stripe

Why you can trust these 1Z0-183 questions

Mapped to the official 1Z0-183 exam objectivesWritten by the Certsqill team7-day money-back guarantee — full refund within 7 days

What is the Oracle DBA certification?

“Oracle DBA certification” is not one credential but a family. As checked on 8 October 2026, Oracle’s certification catalog lists two lines of database administration exams side by side: the Oracle Database 19c-era exams 1Z0-082 (Oracle Database Administration I) and 1Z0-083 (Oracle Database Administration II), and the newer Oracle AI Database Administration Associate (1Z0-182) and Professional (1Z0-183) exams.

The 19c-era route leads to the Oracle Database Administration 2019 Certified Professional, and requires passing both 1Z0-082 and 1Z0-083. The newer route was announced in April 2025 under the name Oracle Database 23ai Administration Professional; the catalog now lists the same exam number, 1Z0-183, as Oracle AI Database Administration Professional.

Alongside these, Oracle lists separate 19c specialist exams — Performance Management and Tuning (1Z0-084), Data Guard Administration (1Z0-076), RAC, ASM and Grid Infrastructure Administration (1Z0-078) and Database Security Administration (1Z0-116). The role all of these target is the working DBA: installing, patching, backing up, recovering and tuning Oracle databases.

Source: Oracle — Oracle Certification. Checked 8 October 2026.

How much does the Oracle DBA certification cost?

We could not verify a price for 1Z0-082, 1Z0-083, 1Z0-182 or 1Z0-183. Oracle’s exam pages on MyLearn only render in a browser, and none of the Oracle pages that do load state a figure. Rather than repeat a number from a third-party site, we leave it open.

Oracle’s certification guidelines explain how pricing works: the exam price is provided in the currency offered by Oracle University, currency conversions are reviewed annually, and Oracle does not refund or adjust for fluctuating exchange rates. You see the binding price when you buy.

One structural difference affects the total: the 2019 Certified Professional needs two exams, the AI Database Administration Professional route one professional exam. Oracle also sells exam attempts within learning subscriptions, which its buying page describes as including three certification exam attempts.

Source: Oracle — Certification Program Guidelines. Checked 8 October 2026.

What is the Oracle DBA exam format?

For 1Z0-183, Oracle University’s announcement states a 120-minute test with 65 questions and a passing score of 60%, taken as an online exam. Those figures date from the April 2025 launch; the exam has since been renamed, and Oracle’s current exam page could not be read for this check.

For 1Z0-082 and 1Z0-083, we could not verify the question count, duration or passing score on any Oracle page that loads without a browser, so this page states none. Check them on Oracle’s exam page at registration.

Oracle’s exam-prep page sets out the rules for online proctored exams: check in at least 30 minutes before the start, be alone in the room, keep camera and microphone on throughout, and use no AI or other technology for assistance during the exam.

Source: Oracle University — Announcing the 23ai Administration Professional certification (April 2025). Checked 8 October 2026.

Oracle DBA passing score

Oracle announced the 1Z0-183 passing score as 60%. With 65 questions across five weighted areas, a weak area costs more than it seems: the largest, performance tuning, is a quarter of the exam on its own.

Oracle’s guidelines state that the passing score is set independently for each exam version to keep a consistent standard across versions. In practice: check the figure for the exact exam version you book, and do not carry a passing score over from 1Z0-082 or 1Z0-083 to 1Z0-183, or the other way round. Oracle also does not tell you which questions you missed.

Source: Oracle University — Announcing the 23ai Administration Professional certification (April 2025). Checked 8 October 2026.

What is on the Oracle DBA exam?

For 1Z0-183, Oracle published the exam weighting at launch. The five areas mirror the five courses in the professional learning path:

For the 2019 route, Oracle’s FAQ does not publish weightings but names recommended courses. For 1Z0-082 these are Oracle Database: Administration Workshop and Oracle Database: Introduction to SQL; for 1Z0-083 they include courses on deploying, patching and upgrading, 19c new features, backup and recovery, and multitenant architecture.

  • Deploy, Patch, and Upgrade — 15%
  • Managing Multitenant Architecture — 20%
  • Performing Backup and Recovery — 20%
  • Managing and Tuning Performance — 25%
  • Oracle Database 23ai New Features for Administrators — 20%

Source: Oracle University — Announcing the 23ai Administration Professional certification (April 2025). Checked 8 October 2026.

Oracle DBA certification prerequisites

For the 2019 Certified Professional, Oracle’s FAQ states that training is not required, though Oracle very strongly recommends it, and strongly recommends taking the exams in order — 1Z0-082 first, then 1Z0-083. Passing 1Z0-082 alone no longer earns anything: Oracle states there is no longer an OCA credential awarded for Oracle Database Administrator.

Holders of older Oracle DBA credentials have upgrade paths. The FAQ describes routes for 10g, 11g, 12c and 12c R2 OCA or OCP holders that run through 1Z0-083, and states that holders of 7.3, 8, 8i or 9i credentials can upgrade to 2019 by passing both exams.

For 1Z0-183, Oracle’s announcement calls the Associate certification the ideal preparation before the professional-level path. The pages we could check do not say whether the Associate is mandatory, so confirm that when you register.

Source: Oracle — Oracle Database Certification Questions Answered (2019 path). Checked 8 October 2026.

How long is the Oracle DBA certification valid?

Oracle’s certification guidelines state that certain Oracle Database credentials require periodic recertification to remain active. They do not name which ones, and they give no validity period for database credentials — unlike Oracle Cloud Infrastructure (24 months) and Oracle Cloud Applications (18 months), for which they do.

So the honest answer is: Oracle has not published a fixed term for these DBA credentials on the pages we could check. Oracle’s guidelines say the badge verification page shows an expiration date where one applies, so check your own badge after you pass.

Source: Oracle — Certification Program Guidelines. Checked 8 October 2026.

Oracle DBA study materials and training

For 1Z0-183, Oracle University’s professional learning path consists of five courses: Oracle Database 23ai Deploy, Patch, and Upgrade; Multitenant Architecture; Backup and Recovery; Performance Management and Tuning; and New Features for Administrators. Each maps onto one weighted exam area.

For the 2019 route, the official material is the set of Oracle University courses named in Oracle’s certification FAQ — the Administration Workshop and Introduction to SQL for 1Z0-082, and the workshops on deployment and upgrade, 19c new features, backup and recovery and multitenant architecture for 1Z0-083.

Whichever route you take, match material to the exam number. 1Z0-183 gives 20% of its weight to 23ai new features for administrators — material written for the 19c-era exams was not written for that area.

Source: Oracle University — 23ai Administration Professional learning path and certification (April 2025). Checked 8 October 2026.

Oracle Database 2019 Certified Professional vs AI Database Administration Professional

The 2019 Certified Professional is the 19c-era route: two exams, 1Z0-082 and 1Z0-083. The AI Database Administration Professional is the newer route built on Oracle Database 23ai content, with one professional exam, 1Z0-183, and an Associate exam, 1Z0-182, recommended before it.

One scope difference Oracle states explicitly: there will be no 23ai version of the standalone Performance Management and Tuning exam. That content is integrated into 1Z0-183, where tuning is the largest area at 25%. On the 19c side, tuning remains a separate exam, 1Z0-084.

If your databases run 19c today, the 2019 route matches what you administer. If you are moving to 23ai, or want the newest credential, 1Z0-183 is the current professional exam.

Source: Oracle University — 23ai Administration Professional learning path and certification (April 2025). Checked 8 October 2026.

Oracle DBA practice questions

Certsqill’s Oracle DBA practice questions come with an explanation for each option and follow Oracle’s published exam areas and weightings — including performance tuning, the heaviest area on 1Z0-183.

Oracle DBA questions people ask

Which Oracle DBA certification is current?

Oracle lists both the 2019 Certified Professional (1Z0-082 + 1Z0-083) and the newer AI Database Administration Professional exam 1Z0-183. Source: Oracle, checked 8 October 2026.

How many questions are on 1Z0-183?

65 questions in 120 minutes, per Oracle’s April 2025 announcement. Source: Oracle University, checked 8 October 2026.

What is the 1Z0-183 passing score?

60%, per Oracle’s April 2025 announcement. Source: Oracle University, checked 8 October 2026.

Which exams make up the Oracle Database Administration 2019 Certified Professional?

1Z0-082 Oracle Database Administration I and 1Z0-083 Oracle Database Administration II. Source: Oracle FAQ, checked 8 October 2026.

Do I get a certification after passing 1Z0-082?

No. Oracle states there is no longer an OCA credential awarded for Oracle Database Administrator. Source: Oracle FAQ, checked 8 October 2026.

Is training required for the Oracle DBA certification?

Not for the 2019 route — Oracle says training is not required but strongly recommended. Source: Oracle FAQ, checked 8 October 2026.

How much does the Oracle DBA certification cost?

No price could be verified on an Oracle page; Oracle states the price is provided in the currency offered by Oracle University. Checked 8 October 2026.

Does the Oracle DBA certification expire?

Oracle says certain Database credentials require periodic recertification but does not name which. Source: Oracle guidelines, checked 8 October 2026.

Oracle Database SQL certification: the SQL Certified Associate

Many people start one step before database administration, with SQL. Oracle’s certification catalog lists the exam 1Z0-071, Oracle Database SQL, and Oracle Academy states that the Oracle Certified Associate credential “is awarded only to candidates who pass the Oracle Database SQL | 1Z0-071 exam.” The credential itself is the Oracle Database SQL Certified Associate certification.

Oracle’s badge description says an Oracle Database SQL Certified Associate “demonstrates understanding of fundamental SQL concepts” needed to undertake any database project — queries, insert, update and delete statements, some Data Definition Language and Data Control Language, the optimizer, tables and indexes, data modeling and normalization.

The catalog also lists a newer SQL exam, 1Z0-171 Oracle AI Database SQL Associate. So the Oracle Database SQL certification now has two exam numbers in the catalog; check which one your employer or course refers to before you book.

Source: Oracle CertView — Oracle Database SQL Certified Associate. Checked 9 October 2026.

Oracle Database associate certification vs professional certification

On the administration side, Oracle uses the same two levels. The Oracle Database associate certification for DBAs is now 1Z0-182, Oracle AI Database Administration Associate. The Oracle Database professional certification comes either from 1Z0-183, Oracle AI Database Administration Professional, or — on the 19c-era route — from passing both 1Z0-082 and 1Z0-083 for the Oracle Database Administration 2019 Certified Professional.

One detail catches people out on the older route: passing 1Z0-082 on its own earns nothing. Oracle’s 2019 FAQ states that there is no longer an OCA credential awarded for Oracle Database Administrator. The associate title on the SQL side is a different credential and comes from 1Z0-071 only.

Source: Oracle — Oracle Certification. Checked 9 October 2026.

What happened to the Oracle Database SQL Expert certification?

Oracle’s current certification catalog, checked on 9 October 2026, does not list an Oracle Database SQL Expert certification or exam. The SQL exams it lists are 1Z0-071 Oracle Database SQL and 1Z0-171 Oracle AI Database SQL Associate, plus 1Z0-149 Oracle Database Program with PL/SQL for procedural code.

If a job advert still asks for the Oracle Database SQL Expert certification, treat it as an older title. The current way to show the same skills is the SQL Certified Associate, optionally followed by the PL/SQL exam.

Source: Oracle — Oracle Certification. Checked 9 October 2026.

Oracle DBA latest version: which exams are newest?

The newest administration exams in Oracle’s catalog are the Oracle AI Database Administration Associate (1Z0-182) and Professional (1Z0-183). Oracle announced 1Z0-183 in April 2025 as the Oracle Database 23ai Administration Professional; the catalog now lists the same exam number under the AI Database name. If you are looking for the Oracle DBA latest version, these two exam numbers are it.

The 19c-era exams have not disappeared: 1Z0-082 and 1Z0-083 are still in the catalog, alongside separate 19c exams for performance tuning, Data Guard and RAC. Choose the line that matches the databases you run — the latest version is not automatically the right one for a 19c shop.

Source: Oracle — Oracle Certification. Checked 9 October 2026.

Oracle DBA syllabus: where the exam topics come from

For 1Z0-183, the closest thing to an official syllabus is the weighting Oracle published at launch: Deploy, Patch, and Upgrade 15%; Managing Multitenant Architecture 20%; Performing Backup and Recovery 20%; Managing and Tuning Performance 25%; and Oracle Database 23ai New Features for Administrators 20%. Each area maps to one course in Oracle University’s professional learning path.

For the 2019 route, Oracle’s FAQ names recommended courses rather than percentages. Read the topic list of the exact exam number you book; material written for 1Z0-082 does not cover the 23ai new-features area of 1Z0-183.

Source: Oracle University — Announcing the 23ai Administration Professional certification (April 2025). Checked 8 October 2026.

Oracle DBA training and courses

Oracle DBA training is optional on the 2019 route: Oracle’s FAQ says training is not required, although Oracle “very strongly” recommends it. The official Oracle DBA courses are Oracle University’s — for 1Z0-082, Oracle Database: Administration Workshop and Oracle Database: Introduction to SQL; for 1Z0-183, the five-course professional learning path, one course per exam area.

If you consider an Oracle DBA boot camp or another intensive course instead, check four things before paying: which exam number it teaches to (1Z0-082/083 or 1Z0-182/183), whether it covers every weighted area — performance tuning is the largest on 1Z0-183 — whether it includes hands-on lab time on a real database, and whether an exam attempt is included or bought separately. A short bootcamp works best for people who already administer Oracle databases day to day; it is not a substitute for that experience.

Source: Oracle — Oracle Database Certification Questions Answered (2019 path). Checked 8 October 2026.

Oracle DBA salary: what Oracle publishes

Oracle publishes no salary data for any of its certifications, and this page quotes none. Oracle DBA salary figures you find online come from job boards and surveys with their own methods; they are not Oracle figures, and they vary widely by country, industry and the databases involved.

The same applies to the senior Oracle DBA salary. Job adverts often list the role as Sr Oracle DBA; salary in those ads reflects years of production experience, on-call responsibility and specialist skills such as Data Guard or RAC far more than a single certificate. If you are comparing offers, look at what the role requires you to run, not just the title.

Source: Oracle — Oracle Certification. Checked 9 October 2026.

Oracle DBA interview preparation

Oracle DBA interview questions and certification exam questions overlap less than people expect. The exam checks whether you know how a feature works; an interviewer asks what you did when it failed. Good Oracle DBA interview preparation therefore starts from your own incidents: a restore you ran, a slow query you fixed, an upgrade that went wrong and how you rolled it back.

Oracle’s published exam areas are still a useful checklist for which topics come up. Typical interview questions on Oracle DBA work follow the same lines:

  • Backup and recovery: how you would recover after losing a datafile, and how you test that backups actually restore.
  • Multitenant architecture: the difference between a container database and pluggable databases, and how you move or clone a PDB.
  • Performance tuning: how you find the statement causing a slowdown and what you check first.
  • Patching and upgrades: how you plan downtime, test a patch and roll back.
  • Security and users: privileges, roles and auditing in a database you are responsible for.

Source: Oracle University — Announcing the 23ai Administration Professional certification (April 2025). Checked 8 October 2026.

Interview questions and answers for Oracle DBA roles

Lists of Oracle DBA interview questions and answers are easy to find, but memorised answers are easy to spot. An interviewer will usually follow a textbook answer with “and what would you do if that did not work?” — so practise explaining your reasoning out loud, not reciting definitions.

When you practise interview questions on Oracle DBA with answers attached, check which version the answers assume. Behaviour differs between 19c and the newer AI Database releases, and a confident answer about the wrong version does more harm than an honest “in 19c it works like this; I would check whether that changed”.

More Oracle DBA questions

What is the Oracle Database SQL Certified Associate certification?

The credential awarded for passing 1Z0-071 Oracle Database SQL. Oracle Academy states the Oracle Certified Associate credential is awarded only to candidates who pass that exam. Checked 9 October 2026.

Is there still an Oracle Database SQL Expert certification?

Oracle’s current catalog does not list one. It lists 1Z0-071 Oracle Database SQL and 1Z0-171 Oracle AI Database SQL Associate. Checked 9 October 2026.

Which is the Oracle DBA latest version?

The newest administration exams in Oracle’s catalog are 1Z0-182 (Associate) and 1Z0-183 (Professional), named Oracle AI Database Administration. The 19c-era 1Z0-082 and 1Z0-083 are still listed too. Checked 9 October 2026.

Is Oracle DBA training required?

Not for the 2019 route: Oracle’s FAQ says training is not required but strongly recommended. The official Oracle DBA course options come from Oracle University.

Is an Oracle DBA bootcamp worth it?

Only if it teaches to the exam number you will sit, covers every weighted area and includes hands-on lab time. Oracle requires no bootcamp for the 2019 route.

What is the average Oracle DBA salary?

Oracle publishes no salary data, so we quote none. Salary for Oracle DBA roles depends mainly on country, experience and the systems you run.

Are Oracle DBA administrator interview questions the same as exam questions?

No. Exams test how features work; interviews ask how you handled real situations. Use the exam areas as a topic list, then prepare examples from your own work.

Where can I find questions for Oracle DBA interview practice?

Start from Oracle’s published exam areas — backup and recovery, multitenant, performance tuning, patching and upgrades — and prepare one real example for each.

Oracle DBA questions are coming soon Leave your email and we'll tell you the moment the question bank goes live. Get notified →
Certsqill Tutor
Every mistake explained by your Certsqill Tutor
Get unstuck on the question you just missed — why your answer was wrong, measured against your own history, in 11 languages. Included with the course.
Study Resource
Complete Oracle Database Administration Professional Exam Guide
Domain breakdown, 4-week study plan, common mistakes, and passing strategies.
Read the Oracle Database Administration Professional Exam Guide →
Related Certifications
Practice these next