Oracle Database Certification Exam Guide

Every current Oracle Database certification exam mapped — 1Z0-071, the 19c DBA track and 23ai — with formats, costs and which to sit first.

Lucas Müller20 May 2026 · 10 min read

Ask AIChatGPT Claude Gemini Copilot Perplexity Grok

Route map showing Oracle Database certification exams branching from the SQL exam into 19c and 23ai administration tracks

Four exams cover almost every Oracle Database certification decision you will face in 2026: 1Z0-071 (the SQL Associate exam, the usual starting point), 1Z0-082 and 1Z0-083 (the two-exam Database Administration 2019 track on Oracle Database 19c), and 1Z0-182 (the single-exam Administration Associate on Oracle Database 23ai). This guide profiles each exam — code, format, cost, who it suits — and gives you a defensible order to take them in, because the most expensive mistake in this track is not failing an exam; it is passing the wrong one first.

Two boundaries, so you know what you are reading. This is the exam-level guide: codes, formats and sequencing. The broader shape of the track — how the credentials ladder together and where they lead — is covered in the Oracle Database certification guide, and Oracle's Java exams are a separate family entirely, mapped in the Oracle Java certification guide.

The map: how Oracle's database exams fit together

Oracle's database credentials follow a two-level pattern. Associate-level exams (Oracle Certified Associate, OCA) establish fundamentals; Professional-level exams (Oracle Certified Professional, OCP) certify the skills of a working administrator. Concretely, as of August 2026:

1Z0-071 — Oracle Database SQL Certified Associate. The entry exam for the whole track. Pure SQL, not administration, and not version-locked to a single database release.
1Z0-082 — Oracle Database Administration I. Passing it makes you an Oracle Database Administration 2019 Certified Associate. Based on 19c, the long-term-support release most enterprises still run on-premises.
1Z0-083 — Oracle Database Administration II. Builds on 1Z0-082 and confers the Oracle Database Administration 2019 Certified Professional credential — the classic senior DBA certification. Covers performance tuning, security, RAC and multitenant administration.
1Z0-182 — Oracle Database 23ai Administration Associate. The associate-level DBA exam for Oracle's current release, 23ai. One exam, one credential, no second paper.

Both administration tracks exist in parallel — Oracle has not retired 19c certification in favour of 23ai — which is precisely why candidates need a decision framework rather than a list. Note also a fact that surprises people coming from cloud certification: Oracle Database credentials do not expire. Oracle retires old exams, but a certification earned stays valid — unlike Oracle's OCI cloud certifications, which lapse after 24 months.

All of these exams cost $245 USD per attempt at list price (fees vary by country and region — confirm on Oracle's site), are delivered through Oracle University with Pearson VUE either online proctored or at a test centre, and a purchased attempt typically has to be scheduled within six months.

Exam profiles: what you actually sit

1Z0-071: the SQL exam almost everyone should sit first

The Oracle Database SQL Certified Associate exam is 63 multiple-choice questions in 120 minutes with a 63% passing score, and it has no prerequisites. It tests core SQL against Oracle Database: SELECT mechanics, joins, subqueries, set operators, DML and DDL, data types and conversion, and the data dictionary.

Why it comes first: every later exam assumes its content, it serves developers and analysts as a standalone credential (plenty of people stop here, entirely reasonably), and it lets you rehearse Oracle's question style — precise, syntax-sensitive, fond of "which two statements are true" — at the least punishing point in the track. The style point matters more than it sounds: Oracle SQL questions routinely turn on whether a statement executes at all, so studying means writing and breaking SQL in a real environment, not reading about it. When you want to see where you stand, ExamPractice's Oracle Database SQL practice questions let you drill by topic and then run a timed simulation before you spend the exam fee.

1Z0-082 and 1Z0-083: the 19c administration pair

The Administration I exam covers the day-one DBA's world — database architecture, instances and storage, users and security basics, backup fundamentals — plus a substantial SQL component. Administration II moves to the senior desk: multitenant architecture, performance tuning, advanced backup and recovery, RAC and Grid Infrastructure concepts. Passing the first makes you a 2019 Certified Associate; adding the second makes you a 2019 Certified Professional, the credential most "Oracle DBA required" job adverts have in mind.

A caution this guide owes you: Oracle adjusts exam formats over time, and current question counts and durations for 1Z0-082 and 1Z0-083 were not independently verifiable at the time of writing — check both live exam pages on education.oracle.com before booking rather than trusting any third-party table, this one included. What is stable is the structure: two exams, in order, $245 each, no expiry on the credentials.

Who this pair suits: anyone administering the databases enterprises actually run. 19c remains the long-term-support release deployed across large on-premises estates, so the 2019 track certifies against the reality of most DBA job descriptions today.

1Z0-182: the 23ai associate exam

The Oracle Database 23ai Administration Associate exam is reported by multiple prep sources as 60 multiple-choice questions in 120 minutes with a 65% passing score, spread across thirteen weighted domains — instances, users, storage and multitenant architecture among them. There is no mandatory prerequisite, though Oracle recommends around a year of hands-on DBA experience, and the recommendation is sincere: this is an administrator's exam, not a theory quiz.

Who it suits: candidates whose employers are adopting Oracle's current release, and newer DBAs who would rather certify against the platform's future than its installed base. Its trade-off is the mirror image of the 19c pair's — a fresher credential, but one exam at associate level, with no 23ai professional-level equivalent of 1Z0-083 in this comparison.

The adjacent exams worth knowing about

Two neighbouring credentials sit just off this map. PL/SQL — Oracle's procedural language — has its own developer-oriented exam, and if your work leans towards database programming rather than administration, the Oracle Database PL/SQL practice questions page shows the kind of ground it covers. And Oracle's open-source database has a separate track entirely: the MySQL 8.0 Database Administrator exam (1Z0-908) runs 73 questions in 120 minutes with a 62% passing score, costs the same $245, and its credential likewise never expires. Neither counts towards the Oracle Database ladder above; both are worth a look if your estate is mixed.

Which exam first? A comparison and a framework

Factor	1Z0-071 (SQL)	1Z0-082/083 (19c DBA)	1Z0-182 (23ai DBA)
Level	Associate	Associate, then Professional	Associate
Exams to credential	One	Two, in sequence	One
Format	63 questions, 120 min, 63% pass	Check live Oracle pages (not verified for 2026)	~60 questions, 120 min, 65% pass (per prep sources)
Cost (USD list)	$245	$245 per exam ($490 for both)	$245
Prerequisites	None	None formal; 082 before 083's credential	None; ~1 year DBA experience recommended
Best for	Developers, analysts, first-time Oracle candidates	DBAs targeting the classic OCP credential and 19c estates	DBAs on Oracle's current release; single-exam route
Career signal	SQL fluency	Senior administration capability	Current-platform administration
Expiry	Never	Never	Never

Now the framework. Answer three questions:

Do you administer databases, or query them? If your work is queries, reports and application data access, sit 1Z0-071 and stop — the administration exams certify a job you don't do. If you administer, continue.
What does your employer (or target employer) run? Certify against the release you will touch. Estates on 19c — still the common case — point to 1Z0-082/083. Organisations adopting 23ai, or roles advertised around Oracle's current platform, point to 1Z0-182. When in doubt, the 19c Professional credential matches more of today's job adverts.
How much certification budget and stamina do you have this year? The 19c Professional route is two exams and roughly double the cost and preparation time. If a single credential this year is the realistic ceiling, 1Z0-071 plus a decision deferred beats an abandoned half-track.

A worked example: a support engineer with two years of SQL experience and ambitions towards a DBA role at a bank running 19c has a clear route — 1Z0-071 first (her SQL is nearly there already), 1Z0-082 within the year, 1Z0-083 when her job includes real tuning and recovery work to hang the study on. The same engineer at a cloud-first startup adopting 23ai swaps the second and third steps for 1Z0-182. Where these credentials lead over a career — and what to stack after them — is the territory of the Oracle certification career path guide, and the administrator role itself, duties and all, has its own dedicated Oracle DBA certification guide.

How to pass: exam-specific tactics

General Oracle study method — resources, schedules, practice-test strategy across every track — has a single home on this site, the guide to preparing for Oracle certification exams, so this section confines itself to what is specific to database exams:

Study inside a database, not beside one. Every claim you read — how a join behaves with nulls, what a multitenant container can see — should be tested against a live instance. Oracle's free database offerings make this practical, and the muscle memory pays directly: these exams punish plausible-sounding syntax that doesn't run.
Learn the question grammar. Oracle's multiple-choice style leans on "choose two/three" formats and options that differ by a single clause. Practise eliminating options for stated reasons; guessing patterns that work on looser exams fail here.
Weight your revision by the blueprint. Each exam page publishes objective domains. Score your practice results against them and spend your final fortnight on your two weakest domains, not your favourite ones.
Simulate the clock before you book. Roughly two minutes per question sounds generous until a 40-line schema question spends five. At least two full-length timed runs — treated as diagnostics to analyse, never as answer sets to memorise — tell you whether to book or defer. ExamPractice offers free sample questions across its Oracle exam pages, with fuller sets and a timed simulation mode for subscribers.

How these exams compare in difficulty to Oracle's Java and cloud papers is a question this guide deliberately leaves to the dedicated analysis of how hard Oracle certification exams are.

Common mistakes on the database track

Skipping SQL to "get to the real DBA exam". Administration I contains a meaningful SQL component, and weak SQL is the most common silent score-killer across the whole track.
Certifying against the wrong release. A 23ai credential impresses nobody at an employer frozen on 19c, and vice versa. Check the estate before you check out study materials.
Trusting third-party format tables. Question counts and durations drift as Oracle refreshes exams. The live exam page is the only source that counts on booking day — this guide's numbers are dated August 2026 and hedged for a reason.
Buying the voucher before the study plan. The six-month scheduling window is shorter than it feels, particularly for the two-exam 19c route.
Confusing exam retirement with credential expiry. Holders of older credentials do not lose them when exams retire; upgrade paths exist for moving to newer releases when a role demands it, so upgrading is a career decision, not an obligation.

Frequently asked questions

Do I need 1Z0-071 before the administration exams?

No — there is no formal prerequisite chain from the SQL exam into either administration track. It comes first in this guide because its content underpins everything after it and it is the gentlest introduction to Oracle's question style, not because Oracle requires it.

Can I go straight to 1Z0-083 for the Professional credential?

The Professional credential is earned through the track, with Administration I as the associate step — plan for the sequence rather than a single-exam shortcut, and confirm the current credential requirements on Oracle's certification pages when you book.

Are Oracle Database exams available online?

Yes. Delivery is through Oracle University with Pearson VUE, either online proctored from home or at a test centre — the same choice across all the exams in this guide.

Should I wait for a 23ai Professional-level exam instead of doing the 19c track?

Waiting for unannounced exams is rarely a strategy. If you need a Professional-level DBA credential now, the 19c track is the route that exists; a 23ai associate credential can complement it later. Certify for the role in front of you.

Booking your first Oracle Database exam

If this guide has done its job, your next step is already narrow: developers and analysts book 1Z0-071; working DBAs pick the administration track that matches their estate and book its first exam. Confirm the format on the live Oracle exam page, buy the attempt only once your preparation has a schedule, and use a timed practice run as the final gate before the fee leaves your account. The credential at the end has two virtues rare in IT certification: it maps to systems that businesses will run for years, and it never expires.

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.