Oracle Database Administrator Certification Guide

How to become an Oracle certified DBA, step by step

1. Get SQL solid first — consider certifying it. Administration exams assume you read and write SQL without thinking. If you are not there yet, the Oracle Database SQL Certified Associate (1Z0-071) — 63 questions, 120 minutes, 63% passing score, $245 USD — is a common on-ramp that also produces a non-expiring credential of its own. It is optional, not a prerequisite.
2. Choose your route with the framework above, and register interest in the current exam version at education.oracle.com. Note Oracle's purchasing rule: an exam purchase must typically be scheduled within six months, so buy when your study plan says you are eight to twelve weeks out, not on day one.
3. Build a lab you break on purpose. Install the database release you are certifying on, then practise the failure modes exams and employers both care about: kill an instance mid-transaction and recover it, misconfigure storage and diagnose it, create and plug pluggable databases until the multitenant model feels mundane. Reading about recovery is not the same skill as performing it under time pressure.
4. Study the objectives as an administrator, not a student. For every exam topic, ask what operational problem it exists to solve. Multitenant questions, for instance, are really questions about consolidation and isolation trade-offs; candidates who understand the why choose correctly when a question's wording is unfamiliar.
5. Rehearse under exam conditions before you book. Timed sets of 1Z0-082 practice questions will expose which domains are still soft — review the misses by topic, restudy, and only re-test with fresh questions so you are measuring understanding rather than recall. When you move to the second exam, 1Z0-083 practice questions serve the same benchmarking role for the tuning and RAC material.
6. Sit the exam via Oracle's channels. Oracle delivers exams through Oracle University with Pearson VUE, online proctored or at a test centre, so home delivery is available if your setup meets the proctoring rules.

Full study-method detail — resource selection, scheduling, and how to use practice tests well across every Oracle track — lives in the guide to preparing for Oracle certification exams.

Mistakes that derail DBA candidates

Treating Administration II as "more of the same". The step up from 1Z0-082 to 1Z0-083 is the real filter in the 19c track: tuning, RAC and security reward operational experience that reading alone cannot fake. Budget more preparation time for the second exam than the first.

Studying from the wrong version's material. Oracle's database exams have long version histories — the retired 11g and 12c upgrade exams still circulate in old study threads — and multitenant behaviour in particular has shifted across releases. Anchor every resource you use to the exact exam code you booked.

Certifying without lab hours. The credential gets you the interview; the whiteboard question about a hung backup gets you the job. Interleave every study block with hands-on work so the two never drift apart.

Ignoring the ecosystem around the core exams. Specialist administration exams exist beyond the main track — for example, 19c RAC, ASM and Grid Infrastructure administration (1Z0-078) and 19c performance management and tuning (1Z0-084) — which make sense as later additions once the OCP is secured, not as substitutes for it.

Confusing Oracle Database with MySQL certification. Oracle also certifies MySQL administrators (the MySQL 8.0 Database Administrator exam, 1Z0-908), but that is a separate product credential; it neither counts toward nor substitutes for the Oracle Database DBA track.

What the credential does and does not do for your career

An Oracle DBA certification verifies a defined body of administration knowledge and signals commitment to the specialism; because Database credentials never expire, it is a one-off investment that stays on your CV permanently. What it does not do is replace demonstrable experience, and pay outcomes vary widely with location, seniority and estate — this guide deliberately quotes no salary figures, and the numbers that can be responsibly cited live in the Oracle certification salary guide. How DBA credentials stack with cloud and developer certifications over a career is mapped in the Oracle certification career path, and whether the investment clears the bar at all is the question the worth-it analysis at /blog/is-oracle-certification-worth-it/ answers.

Frequently asked questions

Do Oracle DBA certifications expire?

No. Oracle Database credentials — the 19c Associate and Professional and the 23ai Associate alike — do not expire. Oracle retires old exams over time, but a credential you have earned remains yours. This differs from OCI cloud certifications, which lapse after 24 months.

Can I skip 1Z0-082 and take 1Z0-083 directly?

Not if you want the OCP: the 19c Professional requires the Associate step via 1Z0-082 first. The single-exam alternative is the 23ai Associate (1Z0-182), which is a different, associate-level credential.

Is training included in the exam fee?

The $245 fee covers the exam attempt only, but Oracle's learning paths on MyLearn are free, so a self-funded candidate's mandatory cost is the exam fee per attempt.

Is 19c certification a dead end now that 23ai exists?

No. Both tracks were live and maintained as of mid-2026, 19c remains the long-term-support release many employers run, and a 19c credential never expires. Choose by the estates you will work on, not by release number alone.

How long does it take to become Oracle DBA certified?

It depends on your starting point, and no fixed figure guarantees success. The practical planning anchor is Oracle's scheduling window — an exam purchase must typically be used within six months — so structure your study to land inside it.

Your route from here

If you have picked your route, the next move is concrete: register for the current exam code, stand up a lab on the matching release, and set a benchmark practice test in your calendar for six weeks out. If you are still torn between 19c and 23ai, default to the estate you will actually administer — and remember the decision is not final, because non-expiring credentials stack rather than compete. Browse the full set of Oracle exam pages, current and legacy, on the Oracle exams hub to see where the administration exams sit among the wider catalogue.