Oracle Database Certification Guide

The Oracle Database certification track from the 1Z0-071 SQL exam to the 19c and 23ai administration credentials — prerequisites, costs and progression.

Lucas Müller31 July 2026 · 9 min read

Ask AIChatGPT Claude Gemini Copilot Perplexity Grok

Isometric river diagram of the Oracle Database certification path splitting from the SQL exam into 19c and 23ai administration routes

The Oracle Database certification track has one entry door and a fork behind it. Nearly everyone starts with the Oracle Database SQL Certified Associate exam (1Z0-071); from there, candidates heading into administration choose between the two-exam Oracle Database Administration 2019 track built on 19c (exams 1Z0-082 and 1Z0-083) and the newer single-exam Oracle Database 23ai Administration Associate (1Z0-182). All of these credentials cost $245 USD per exam at list price, have no mandatory prerequisites, and — unlike Oracle's cloud certifications — never expire.

This guide walks the track itself: what each exam covers, what the requirements really are, how the progression works, and how to sequence the fork. It stays at the level of the certification path — for what the DBA job actually involves and how the administrator credential maps to it, see the Oracle DBA certification guide, and for study methods and scheduling, the dedicated guide on preparing for Oracle certification exams.

Who this track is for

Oracle Database credentials serve a wider audience than the "DBA certification" label suggests. Three groups get direct value:

Aspiring and working DBAs, for whom the administration exams are the core professional credential.
Developers and data analysts, for whom the SQL exam certifies a transferable skill without committing to administration at all.
Developers building inside Oracle Database, who can add a PL/SQL programming credential on top of the SQL foundation.

Because the entry exam is pure SQL, you do not need server access, root privileges or an ops background to start this track — a practice schema and a query editor are enough.

Step 1: Oracle Database SQL Certified Associate (1Z0-071)

The 1Z0-071 exam is the track's foundation and Oracle's standard entry SQL credential. The essentials, as published on Oracle's exam page:

Format: 63 multiple-choice questions in 120 minutes, with a 63% passing score.
Cost: $245 USD for one attempt (list price — it varies by country and local taxes), and the attempt must be scheduled within six months of purchase.
Prerequisites: none.
Validity: the credential does not expire.
Scope: core SQL on Oracle Database — it is not locked to a single database release, which is part of why it has stayed the standard entry exam rather than being replaced version by version.

That format rewards a particular kind of preparation. Just under two minutes per question sounds generous until you meet items that ask what a subtle multi-table query returns — reading speed on SQL matters as much as syntax recall. And a 63% threshold means you can miss roughly a third of the questions and still pass, which argues for breadth across all the objectives over perfection in your favourite topics.

A realistic profile: a reporting analyst who writes SELECT statements daily will find their joins and aggregate functions well covered but often has gaps in DDL, constraints and transaction control, because production reporting rarely touches them. The exam tests the whole SQL surface, not the querying subset most jobs exercise.

Once you have worked through the official objectives, free Oracle Database SQL (1Z0-071) sample questions will show you how the exam phrases things; ExamPractice subscribers can also run fuller question sets in timed simulation mode to check pacing against that 120-minute limit before booking.

Step 2: choose your administration route

Behind the SQL exam sits the fork. Oracle currently maintains two administration routes in parallel, and understanding why both exist makes the choice easier: Oracle Database 19c is the long-term-support release that a great many employers still run in production, while 23ai is Oracle's current release. Oracle kept the 19c certification track alive alongside the new one because the installed base demanded it.

Route A: the 19c track (1Z0-082 + 1Z0-083)

The Oracle Database Administration 2019 track is a two-exam ladder:

Pass 1Z0-082 (Oracle Database Administration I) to earn the Oracle Database Administration 2019 Certified Associate title.
Pass 1Z0-083 (Oracle Database Administration II) — covering performance tuning, security, Real Application Clusters (RAC) and the multitenant architecture — to earn the Oracle Database Administration 2019 Certified Professional title.

Each exam is $245 USD, both remain offered as of 2026 with their supporting courses actively maintained, and the resulting credentials do not expire. Oracle has not kept stable public question counts and durations for these two exams across recent cycles, so check the live pages at education.oracle.com for current format details rather than trusting older blog posts.

The 19c route's structural appeal is the staged titles: you bank an Associate credential halfway, and finish with a Professional one — the strongest title in the track short of Oracle Certified Master.

Route B: the 23ai Associate (1Z0-182)

The Oracle Database 23ai Administration Associate is the one-exam route aligned with Oracle's current release (branded "Oracle AI Database" in some 2026 materials). Prep sources consistently describe it as 60 multiple-choice questions in 120 minutes with a 65% passing score across thirteen weighted domains — instances, users, storage and the multitenant architecture among them — though those figures come from third-party mirrors rather than a confirmed Oracle page, so verify before you book. It costs $245 USD, has no mandatory prerequisite, and Oracle recommends roughly a year of DBA experience. Like the rest of the track, it never expires.

How to decide between them

The fork is less risky than it looks, because nothing you earn lapses — you can take one route now and add the other later. Use these tests:

Match the estate. If the databases you administer (or want to administer) are 19c, certify on 19c. Credential-to-environment fit beats release recency in interviews.
Weigh title against effort. The 19c route costs two exams and ends in a Professional title; the 23ai route costs one exam and ends at Associate. If a Professional title matters for your seniority signalling, that is a point for 19c.
Consider your runway. Earlier-career candidates with limited study time often do better finishing one exam than stalling halfway through two.
Watch your employer's roadmap. If a 23ai migration is genuinely scheduled rather than merely discussed, certifying on the release you are about to run is the more useful preparation.

Optional add-on: PL/SQL

For developers who build stored procedures, packages and triggers inside Oracle Database, Oracle offers a PL/SQL programming exam that extends the SQL foundation into procedural code. It is a developer-flavoured branch of the track rather than a step on the administration ladder — relevant if your day job is writing database code, safely skippable if you are heading toward operations. ExamPractice hosts sample questions for the Oracle Database PL/SQL exam (1Z0-149) if you want to gauge what that exam asks before committing.

What are the actual requirements?

Candidates routinely overestimate the formal barriers on this track, so here is the requirements picture in one place:

No degree, course or work-experience requirement exists for any exam discussed here. The "requirements" are passing scores, not admission criteria.
No exam requires another exam first, with one exception: the 19c Professional title requires 1Z0-082 before 1Z0-083, because the ladder is sequential by design.
Training is not a paid prerequisite. Oracle's learning paths on MyLearn are free; the $245 fee buys the exam attempt.
Scheduling has one hard rule: an exam purchase must typically be scheduled within six months.
Delivery is flexible: exams run through Oracle University with Pearson VUE, either online proctored from home or at a test centre.

The soft requirements are real, though. The SQL exam presumes enough practice to read unfamiliar queries quickly; the administration exams presume you have actually operated a database — Oracle's recommendation of about a year of experience before 1Z0-182 is honest guidance, not gatekeeping.

How the progression fits together

Laid end to end, the track looks like this:

1Z0-071 → Oracle Database SQL Certified Associate. The universal first step.
Either 1Z0-082 → Administration 2019 Certified Associate, then 1Z0-083 → Administration 2019 Certified Professional; or 1Z0-182 → Database 23ai Administration Associate.
Optionally, the PL/SQL exam alongside either route for database developers.
Beyond all of this sits Oracle Certified Master, a performance-based tier priced well above the written exams and aimed at senior specialists — worth knowing exists, not worth planning around early.

Note what the progression does not include: any renewal treadmill. Every credential above is permanent. The flip side is that the release year becomes part of how employers read the title — an "Administration 2019" certification signals 19c-era skills — which is exactly why Oracle introduced the 23ai exam alongside it and why adding a newer credential later is sometimes worth doing even though the old one never lapses. If you want the exam-by-exam objective detail beneath this progression, the Oracle Database certification exam guide maps each paper individually.

Readiness checklist before you book

Booking $245 exams on a hunch is an expensive habit. Run this check first — for the SQL exam, though the pattern adapts to the administration papers:

You have read the official exam objectives on education.oracle.com from top to bottom and can name your three weakest topic areas without guessing.
You have written SQL against a live practice schema for the topics you only know from reading — constraints, views, sequences and transaction control included.
You have completed at least one full-length timed practice run and finished inside 120 minutes with room to review flagged questions.
Your practice scores sit comfortably above the passing threshold across all objective areas, not just on your strong domains — a strong average hiding a weak domain is how prepared candidates fail.
You have checked the live exam page for the current fee, format and any changes since your study materials were published.

If any line fails, the fix is targeted study rather than a later exam date by reflex — analysing which domains drag your practice scores down, and drilling those, moves the needle fastest. The full method belongs to the preparation guide; how this track's difficulty compares with Oracle's Java and cloud exams is assessed in how hard are Oracle certification exams?

Frequently asked questions

Is there a separate "Oracle 19c certification" for SQL?

No — the SQL exam (1Z0-071) is not version-locked to 19c or any single release; it certifies core SQL on Oracle Database generally. The release-specific credentials in this track are the administration ones: Administration 2019 (19c) and the 23ai Associate.

Do Oracle Database certifications expire?

No. SQL, 19c administration and 23ai administration credentials are all permanent. This is the opposite of Oracle's cloud certifications, which lapse after 24 months — a distinction explained fully in our Oracle certifications overview.

Can I skip 1Z0-071 and go straight to an administration exam?

Formally yes for 1Z0-182, since it has no enforced prerequisite. Practically, the administration material presumes SQL fluency, and the SQL credential is the one that also serves you if you later pivot toward development or analytics — most candidates are better served taking the track in order.

Which is worth more to employers: the 19c Professional or the 23ai Associate?

It depends on the estate they run. A 19c shop reads the Administration 2019 Certified Professional as directly relevant seniority; an organisation moving to 23ai values the newer credential's alignment. Where market value in general is the question, our verdict piece on whether Oracle certification is worth it weighs cost against payoff by track.

How much does the whole track cost?

At list prices: $245 for the SQL exam, then either $490 for the two 19c exams or $245 for the 23ai exam — so $490 to $735 end to end before any retakes, with free official learning paths on MyLearn. Prices vary by country; confirm on each exam's page.

Mapping your first year on the track

A workable twelve-month shape for someone starting from solid-but-uncertified SQL: two to three months of objective-driven study and practice runs, then the 1Z0-071 exam; a pause to bank real operational experience; then the administration route your environment dictates in the back half of the year — 1Z0-182 as a single milestone, or 1Z0-082 with 1Z0-083 held for the following year. Because nothing on this track expires, an unhurried sequence costs you nothing but time, and each credential you bank keeps its value while you work toward the next. Start by reading the 1Z0-071 objectives tonight, benchmark yourself against a timed sample set this week, and let your score — not your optimism — set the booking date.

Exam facts in this guide were checked against official certification-provider pages on 30 August 2026. Fees, exam codes and policies change — confirm on the provider’s own site before you book.