SQLMentor // cert practice
← All certifications
// 1Z0-082 practice

Oracle Database Administration I (1Z0-082)

Full-length timed practice exams modelled on the Oracle Database Administration I (1Z0-082) certification. Each set has 72 questions and a 120-minute window. Three difficulty sets — Foundations, Administration, and Advanced — so you can build progressively.

72questions per exam
120minute timer (auto-submit)
60%passing score
3difficulty sets

About this certification

The Oracle Database Administration I (1Z0-082) is Oracle's foundational DBA certification, replacing the older 1Z0-062 OCA path. It validates that you can install, configure, manage, and troubleshoot an Oracle Database — covering architecture through backup & recovery. Combined with the second DBA exam it leads to the Oracle Database Administrator Professional credential.

Register on Oracle University ↗

Exam format

  • Questions: 72 multiple choice
  • Duration: 120 min (≈ 1 min 40 s / question)
  • Pass mark: 60%
  • Delivery: Pearson VUE or Oracle Online Proctoring
  • Cost: US$245 (varies by region)
  • Re-take wait: 14 days minimum if you fail
Topics covered & study plan

Topics covered

Oracle Database architecture (instances, processes, memory, storage), managing database instances, networking (listener, services, tnsnames), user security (users, profiles, privileges, roles), storage management (tablespaces, undo, redo, controlfiles), space management, moving data (Data Pump, SQL*Loader, External Tables), and basic backup/recovery.

Recommended study plan

  1. Read Oracle's Database Concepts guide for the architecture chapters.
  2. Install Oracle Database 19c or 21c Express Edition locally.
  3. Practise every command in sqlplus — don't just memorise.
  4. Take Practice Set 1 under timing and note every wrong answer.
  5. For each wrong answer, find the relevant Oracle docs section and read it.
  6. Aim for ≥ 70% on practice sets before the real exam.

Pick a set to begin

Loading exam sets…
How the exam works
  • The 120-minute timer starts the moment you click Start exam.
  • Use the question grid to jump between questions; flag any you want to revisit.
  • Click Submit exam at any time to finish early; if the timer reaches zero, the exam auto-submits.
  • After submission you'll see your score, pass/fail status, weak topics, and per-question feedback.
  • Start with Basic to build Database Administration fundamentals, then progress to Advanced.
  • Your progress is kept in the browser only — refreshing during an exam will reset it.

Frequently asked questions — 1Z0-082

How many questions are on the 1Z0-082 exam?
The 1Z0-082 exam contains 72 multiple-choice questions to be answered in 120 minutes. SQLMentor's free practice sets mirror that format so the timing feels familiar on exam day.
What is the passing score for 1Z0-082?
The official passing score for the 1Z0-082 exam is 60%. Each SQLMentor practice set is scored against that same threshold and shows a clear PASS or FAIL on the results screen.
How long should I prepare for the 1Z0-082 exam?
Most candidates prepare for 4 to 8 weeks with consistent daily study. We recommend reading through the SQLMentor tutorials first, then running timed practice sets in the final two weeks until you score above 60% consistently.
Is the SQLMentor 1Z0-082 practice exam free?
Yes. Every 1Z0-082 practice set on SQLMentor is 100% free with no sign-up, no email gate and no paywall. Your progress is saved locally in your browser.
What topics does 1Z0-082 cover?
Oracle architecture, database creation, instance management, storage, undo and redo, backup and recovery basics, network configuration, user and privilege management, and core SQL needed for DBAs. The SQLMentor sets are organised so each set samples across all of these areas to give you a realistic mix on every attempt.