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.
| 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.
Oracle Database Testimonials... (Write a Testimonial!)
The 1Z0-076 premium mock tests are just like the actual Oracle Database 19c - Data Guard Administration certification exam. They have the same questions, multiple-choice answers, scoring system, and time limit. So, if I do well in the mock exam, I know I'll do well in the real one too. And that's exactly what happened. Thanks to the mocks, I felt calm and confident during the actual exam.
JamalcantuMay 2 2024 - 13:40Your Oracle Database Administration I rocks! and all the questions are awesome! Yesterday I passed 1Z0-082 Oracle Database Administration I Certification - this is only because of your incredible application :-) Thanks a lot!
farrellefrain287Apr 25 2024 - 11:29Words fail to capture my gratitude today! Thanks to this site's premium questions and simulated tests, I successfully cleared the actual Oracle Certified Professional, Oracle Database 19c - Performance Management and Tuning (1Z0-084) certificate exam. Friends, I've achieved a good score in the 1Z0-084 certification exam, and I couldn't be happier!
donaldsonizaiahApr 23 2024 - 10:34Working with Composite Data Types and Handling Exceptions topics were quite tough for me initially, before i actually started giving 1Z0-149 mock tests online. However, they eventually became easy and i did not even realize. Once when i scored well in a mock test, i came to know that i was able to answer the questions on these topics. My confidence shot up and i cleared the actual 1Z0-149 exam at first attempt.
MsheriApr 20 2024 - 18:42When it comes to preparing for the Oracle Database Security Administration certification exam, these online mock tests are unbeatable. Expertly designed and meticulously crafted, the practice tests for 1Z0-116 are truly exceptional. Don't hesitate to make the most of your available time by giving these tests your all.
Kailyncopeland4Apr 17 2024 - 04:46
