OCA logo
Focused certification exam prep
Start practice

OCA Passing Score 2026: Exactly What You Need to Pass

TL;DR
  • You need 60% correct to pass Oracle Database Administration I, exam 1Z0-082.
  • The exam has 72 multiple-choice questions and a 120-minute time limit - roughly 100 seconds per question.
  • There's no published minimum per domain; 60% is an overall score across all 23 content areas.
  • 1Z0-082 is validated against Oracle Database 19c, so answers must reflect 19c behavior, not older or newer versions.

The Actual Passing Score for 1Z0-082

If you searched for this page, you probably want one number, so here it is: Oracle requires 60% to pass Oracle Database Administration I, exam 1Z0-082. The exam consists of 72 multiple-choice questions delivered in a 120-minute window, and it is administered by Oracle Corporation through Oracle University. There's no separate "written" and "practical" score to juggle - it's one exam, one score, one threshold.

Do the arithmetic and 60% works out to roughly 43-44 correct answers out of 72. That's the target number to hold in your head during practice tests, not an abstract percentage. When you're grinding through a mock exam and want to know if you're on pace, count your correct answers against that raw number rather than recalculating percentages mid-review.

Important context: 1Z0-082 is not a standalone "OCA" credential in the way this site's name implies. It's Step 1 of the current Oracle Database Administration 2019 Certified Professional path, and candidates can alternatively satisfy that step with the newer Oracle Database 23ai Administration Associate credential before moving to 1Z0-083. Understanding this path matters as much as the passing score itself - see our OCA Certification overview for the full picture.

How the 72 Questions Are Scored

Because 1Z0-082 is multiple-choice, scoring mechanics are simpler than exams with performance-based labs. Each question is worth an equal share of the total, and your raw score converts to the percentage measured against the 60% bar. There's no partial credit for "almost right" answers on multi-select questions - you typically need every correct option selected and no incorrect ones, which is a detail candidates underestimate when they assume partial matches count.

The exam is validated against Oracle Database 19c. That single fact should shape how you interpret every ambiguous question during practice: if a topic behaves differently across Oracle versions (and several do, especially around storage management and default parameters), the 19c behavior is the one being tested. Studying from mismatched-version documentation or outdated blog posts is one of the quiet ways candidates lose points without realizing it.

Key Takeaway

Treat 60% as a floor, not a target. Aim your practice-test scores at 75-80% consistently before scheduling the real exam, because timed-exam anxiety and unfamiliar question phrasing typically cost a few points on test day.

Does Every Domain Need 60%?

No - Oracle publishes an overall passing score, not domain-by-domain minimums, for 1Z0-082. That means you could theoretically score low on one content area and compensate with strength elsewhere, as long as your total crosses 60%. In practice, though, this is a risky strategy because the exam spans 23 distinct content areas, and skipping any of them entirely leaves too much exposure.

The 23 domains split roughly into two clusters: core database administration topics and SQL-focused topics. Here's the full list as tested:

Domain ClusterRepresentative Domains
Database AdministrationUnderstanding Oracle Database Architecture, Managing Users Roles and Privileges, Managing Tablespaces and Datafiles, Managing Database Instances, Managing Storage, Configuring Oracle Net Services, Managing Undo
Data Movement & AccessMoving Data, Accessing an Oracle Database with Oracle Supplied Tools
SQL FundamentalsRestricting and Sorting Data, Displaying Data from Multiple Tables Using Joins, Understanding Data Definition Language, Retrieving Data using the SQL SELECT Statement, Reporting Aggregated Data Using Group Functions
SQL Functions & StructuresManaging Data in Different Time Zones, Using Single-Row Functions to Customize Output, Using Subqueries to Solve Queries, Managing Sequences Synonyms Indexes, Using Conversion Functions and Conditional Expressions, Using SET Operators, Managing Views, Managing Tables using DML statements, Managing Schema Objects

For the exhaustive breakdown of what each of the 23 areas covers, our OCA Exam Domains 2026: Complete Guide to All 23 Content Areas walks through every one individually. It's worth reading before you build a study schedule, because uneven domain coverage is the single biggest reason candidates land just under 60% on their first attempt.

Understanding Oracle Database Architecture

Candidates must understand memory structures, background processes, and how the instance relates to the database files. This domain underpins nearly every other administration topic on the exam.

  • Know the difference between instance and database
  • Understand SGA and PGA components at a conceptual level

Managing Tablespaces and Datafiles

Expect questions on tablespace types, datafile management, and how storage decisions affect availability.

  • Understand permanent vs. temporary vs. undo tablespaces
  • Know how to resize and add datafiles

SQL Domains vs. Architecture Domains: Where Points Get Lost

A pattern shows up consistently among candidates who fall short of 60%: they over-prepare for administration topics they find "interesting" (instances, storage, undo) and under-prepare for SQL domains they assume are "easy" because they've used SELECT statements before. That assumption is dangerous. Domains like Using Subqueries to Solve Queries, Using SET Operators, and Using Conversion Functions and Conditional Expressions contain plenty of edge cases - NULL handling in subqueries, the exact behavior of UNION versus UNION ALL, implicit versus explicit data type conversion - that trip up people who "know SQL" from job experience but haven't drilled the specific syntax rules Oracle tests.

Conversely, some candidates with strong SQL backgrounds neglect Managing Undo, Configuring Oracle Net Services, and Managing Storage because those feel unfamiliar and administration-heavy. Both imbalances produce the same outcome: a candidate who's comfortable in half the material and shaky in the other half, landing somewhere in the 45-58% range instead of comfortably past 60%.

Practical fix: Score your practice tests by domain cluster, not just overall percentage. If your SQL-domain accuracy and your administration-domain accuracy differ by more than 15-20 points, you have an imbalance to correct before exam day.

If you're unsure how difficult this balancing act really is compared to other paths, How Hard Is the OCA Exam? Complete Difficulty Guide 2026 breaks down where the real friction points tend to be for candidates coming from a pure SQL background versus a pure DBA background.

120 Minutes, 72 Questions: The Real Constraint

Passing score conversations tend to focus only on accuracy, but the 120-minute limit is just as decisive. Divide it out: 120 minutes across 72 questions gives you about 100 seconds per question on average. That's workable for straightforward recall questions but tight for scenario-based questions that describe a multi-step administration task and ask you to identify the correct outcome or the correct SQL statement.

A common failure mode isn't lack of knowledge - it's running out of time on the last 10-15 questions after spending too long second-guessing earlier ones. Since the passing bar is a flat 60% of all questions, a rushed guess on the final stretch of questions can cost you the couple of points separating a pass from a retake.

Key Takeaway

During practice exams, track your pace at the 60-minute mark. You should be at or past question 36 (halfway through 72) by then. If you're consistently behind, practice flagging uncertain questions and moving on rather than dwelling.

Building a Score-Focused Study Plan

Rather than studying domains in the order Oracle lists them, sequence your preparation around where points are easiest to secure first, then move into higher-effort areas. This isn't generic study advice - it's specific to how 1Z0-082's 23 domains are structured, with foundational SQL topics unlocking faster comprehension of later administration topics.

Week 1

SQL Foundations

  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
Week 2

Multi-Table and Aggregate SQL

  • Displaying Data from Multiple Tables Using Joins
  • Reporting Aggregated Data Using Group Functions
  • Using Subqueries to Solve Queries
  • Using SET Operators
Week 3

Schema Objects and DML/DDL

  • Understanding Data Definition Language
  • Managing Tables using DML statements
  • Managing Sequences, Synonyms, Indexes
  • Managing Views and Managing Schema Objects
Week 4

Core Architecture and Instance Management

  • Understanding Oracle Database Architecture
  • Managing Database Instances
  • Managing Users, Roles and Privileges
Week 5

Storage, Undo, and Networking

  • Managing Tablespaces and Datafiles
  • Managing Storage
  • Managing Undo
  • Configuring Oracle Net Services
Week 6

Data Movement, Time Zones, Conversions, Review

  • Moving Data and Accessing an Oracle Database with Oracle Supplied Tools
  • Managing Data in Different Time Zones
  • Using Conversion Functions and Conditional Expressions
  • Full-length timed practice tests

For a more detailed week-by-week methodology, including how to layer spaced review sessions on top of this sequence, see the OCA Study Guide 2026: How to Pass on Your First Attempt. And if you want a compact reference to keep open during final review, the OCA Cheat Sheet 2026: One-Page Review of Must-Know Facts condenses the highest-yield syntax and concepts across all 23 domains.

What Happens If You Miss the Passing Score

Falling short of 60% simply means retaking 1Z0-082. Since Oracle's model is a straightforward pass/fail against one score threshold, there's no partial certification or "conditional pass" - you either cross 60% or you schedule again. Before retaking, review which domain cluster (SQL or administration) pulled your score down, using the same domain-tagging approach mentioned earlier, and concentrate your remaining study time there instead of re-reviewing material you already answered correctly.

If cost is a factor in deciding how much runway you have for a potential retake, OCA Certification Cost 2026: Complete Pricing Breakdown lays out what to budget for exam attempts. And if you're weighing whether the retake effort is worth it relative to career impact, Is the OCA Certification Worth It? Complete ROI Analysis 2026 covers that decision in more depth.

Scheduling note: Plan your exam date around your actual readiness, not an arbitrary deadline. Our OCA Exam Dates 2026: Testing Windows, Deadlines & Scheduling guide explains how Oracle University scheduling works so you can build in buffer time before committing to a date.

Beyond the Score: What Certification Actually Signals

Once you clear 60%, 1Z0-082 credentials you as having demonstrated the SQL fundamentals and database administration concepts Oracle recommends candidates already have experience with before attempting the exam. It's the first of two exams (paired with 1Z0-083) required for the current Oracle Database Administration 2019 Certified Professional path - candidates can also satisfy that first step through the newer Oracle Database 23ai Administration Associate credential, so it's worth confirming which route aligns with the Oracle Database version you work with day to day.

For organizations hiring database administrators, this exam signals that a candidate can navigate tablespace management, user privilege structures, undo configuration, and core SQL operations without hand-holding. If you're mapping how this fits into a broader career trajectory, OCA Jobs and OCA Salary Guide 2026: Complete Earnings Analysis cover the practical employment angle, while OCA Requirements 2026: Eligibility, Prerequisites & How to Qualify clarifies what Oracle recommends before you sit the exam in the first place.

To validate your readiness against realistic question formats and timing before exam day, running full-length simulations on our practice test platform is the closest substitute for the actual testing experience. Repeating those simulations under real time pressure - not just reviewing flashcards - is what turns a borderline 55% into a confident 70%+.

Frequently Asked Questions

What score do I need to pass 1Z0-082?

You need 60% correct on the 72-question, 120-minute multiple-choice exam. That works out to roughly 43-44 correct answers.

Is the passing score the same across all 23 domains?

Oracle publishes one overall passing score of 60% rather than separate minimums per domain, but weak coverage in any single domain still increases your risk of falling short overall.

Which Oracle Database version is 1Z0-082 based on?

The exam is validated against Oracle Database 19c, so all answer choices should be evaluated against 19c behavior specifically.

Does passing 1Z0-082 give me a standalone OCA certification?

No. 1Z0-082 is Step 1 of the Oracle Database Administration 2019 Certified Professional path, which also requires passing 1Z0-083. Candidates can alternatively satisfy Step 1 with the Oracle Database 23ai Administration Associate credential.

How many questions can I miss and still pass?

Since 60% of 72 questions is roughly 43-44 correct, you have room to miss around 28-29 questions and still pass, though aiming higher gives you a safety margin against pacing or partial-credit issues on multi-select items.

Ready to pass your OCA exam?

Put this into practice with free OCA questions across every exam domain.