Oracle Database Certification

Oracle Database certifications prove you can query, administer, tune and secure Oracle databases. Oracle currently offers 12 Database exams, from Database Foundations for beginners to Associate and Professional exams for SQL developers and DBAs, on both Oracle AI Database (26ai) and Oracle Database 19c. The table lists each exam's official question count, time limit and passing score.

Oracle Database Certification Practice Exams
Exam Level Questions Time Passing score
1Z0-006: Oracle Database Foundations Foundations 60 120 min 60%
1Z0-071: Oracle Database SQL Associate 63 120 min 63%
1Z0-171: Oracle AI Database SQL Associate Associate 60 120 min 65%
1Z0-182: Oracle AI Database Administration Associate Associate 60 120 min 65%
1Z0-076: Oracle Database 19c: Data Guard Administration Professional 74 120 min 61%
1Z0-078: Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Professional 77 120 min 65%
1Z0-082: Oracle Database Administration I Professional 72 120 min 60%
1Z0-083: Oracle Database Administration II Professional 68 120 min 57%
1Z0-084: Oracle Database 19c - Performance Management and Tuning Professional 55 90 min 60%
1Z0-116: Oracle Database Security Administration Professional 72 120 min 59%
1Z0-149: Oracle Database Program with PL/SQL Professional 65 90 min 66%
1Z0-183: Oracle AI Database Administration Professional Professional 65 120 min 60%

Questions, time and passing score: Oracle University exam pages, checked October 2026. Each exam page has free sample questions; the premium practice exam gives 2 months of unlimited Full and Mini attempts.

Which exam should you take?

  • New to databases: Start with 1Z0-006 Oracle Database Foundations, the only Foundations-level exam in this list.
  • SQL developers and analysts: Take 1Z0-071 Oracle Database SQL, or the newer 1Z0-171 Oracle AI Database SQL Associate if you work on 26ai.
  • DBAs on Oracle AI Database (26ai): Begin with 1Z0-182 Administration Associate, then move on to 1Z0-183 Administration Professional.
  • DBAs on Oracle Database 19c: Take 1Z0-082 Administration I and 1Z0-083 Administration II, then specialise: 1Z0-076 Data Guard, 1Z0-078 RAC, ASM and Grid Infrastructure, 1Z0-084 Performance Management and Tuning, or 1Z0-116 Security Administration.
  • PL/SQL developers: Take 1Z0-149 Oracle Database Program with PL/SQL.

Frequently asked questions

How many questions are on Oracle Database certification exams?

Between 55 and 77. Most exams last 120 minutes; 1Z0-084 and 1Z0-149 last 90 minutes. Passing scores range from 57% (1Z0-083) to 66% (1Z0-149).

Should I take the 19c or the AI Database (26ai) exams?

Both tracks are live. Choose the release your employer runs: the 26ai exams (1Z0-171, 1Z0-182, 1Z0-183) cover Oracle's newest database, the 19c exams cover the long-term release most companies still run.

Which Oracle Database exam is the easiest to start with?

1Z0-006 Oracle Database Foundations is the entry-level exam: 60 questions in 120 minutes with a 60% passing score.

See every Oracle certification practice exam on the Oracle certification page.

No votes yet

Oracle Database Testimonials... (Write a Testimonial!)

  • Achieved Confidence for Oracle Exam

    Online practice sessions were a reliable resource for my Oracle online quiz. As a professional in this field, the material provided was such a helpful tool for achieving certification.

    shermancarl
    Aug 29 2026 - 06:24
  • My Oracle Quest Completed: Proof Brains Can Multitask (Sometimes).

    Juggling a job and studies together felt a bit like attempting to solve a Rubik's Cube while riding a rollercoaster blindfolded. Thankfully, the online mock exams were my trusty guide, revealing where my PL/SQL logic occasionally veered into uncharted, nonsensical territory. They truly illuminated the exact concepts that needed more attention, saving my brain from unnecessary detours and dramatic internal monologues. I'm pretty sure my cat now understands the fundamental principles of 'SELECT ' queries, given his constant supervision. What a surprisingly pleasant experience overall, transforming potential confusion into genuinely clear understanding. My gray matter can finally take a well-deserved, albeit brief, break from advanced syntax.

    william623
    Aug 25 2026 - 19:49
  • Online Quiz Set: A Professional's Path to Oracle Success

    Preparing for my Oracle test as a professional using the online quiz set turned out to be quite an engaging experience. Who knew studying could be this effective and a bit of a chuckle? It was so useful and good, providing precisely what was needed. Successfully navigating those challenges felt rewarding, culminating in a triumphant 'cheers!'

    holmeszion
    Aug 24 2026 - 19:04
  • Practice Made Oracle SQL Easier.

    The interactive online exams were exceptionally helpful for the Oracle Database SQL certification, making challenging topics like 'Restricting and Sorting Data' much clearer. This proved a smarter, more effective learning method than video tutorials, serving as such a helpful tool.

    rudy1991
    Aug 24 2026 - 01:40
  • Database Conquered! My Brain Made It Through Alive!

    The mock exams were a blast, truly transforming database administration from a puzzle into a party! Such a helpful tool, especially when tackling those tricky queries across all my devices.

    alliesteele
    Aug 17 2026 - 21:19