What Is OCA?

What Is 1Z0-082, the Exam Behind "OCA"?

On this site, "OCA" is shorthand for a very specific thing: Oracle Database Administration I, exam code 1Z0-082. Oracle Corporation administers this exam through Oracle University, and it's designed to validate that a candidate understands core Oracle Database architecture, SQL fundamentals, and day-to-day administration tasks on Oracle Database 19c.

It's worth being precise here because the acronym "OCA" gets reused across unrelated fields, and importing facts from a different program onto this exam would misinform anyone preparing for it. Everything discussed in this article - question counts, passing score, domains, and the certification path - applies specifically to 1Z0-082 as administered by Oracle.

Oracle recommends that candidates have prior experience with Oracle Database, an understanding of database administration concepts, and familiarity with SQL fundamentals before attempting the exam. This isn't a strict prerequisite check at registration - Oracle doesn't gate registration behind mandatory training - but the exam content assumes you already know how to navigate a database environment. If you're unsure whether your background is sufficient, our OCA Requirements 2026: Eligibility, Prerequisites & How to Qualify guide walks through what "recommended experience" actually means in practice.

Exam Format, Scoring, and Registration Mechanics

1Z0-082 is a multiple-choice exam consisting of 72 questions, to be completed in 120 minutes. That works out to less than two minutes per question on average, though in practice some questions (especially SQL syntax and multi-table join scenarios) take longer than others. Time management matters more than most candidates expect going in - a topic we cover in depth in our How Hard Is the OCA Exam? Complete Difficulty Guide 2026 article.

To pass, you need a score of 60%. That's the only passing threshold Oracle publishes for this exam, and it applies uniformly - there's no separate cut score for different domains or question types. For a deeper look at exactly how that percentage translates to correct answers out of 72 questions, read OCA Passing Score 2026: Exactly What You Need to Pass.

Registration happens through Oracle University, and the exam itself is tied to a specific database version - currently Oracle Database 19c. That version alignment matters: study material written against a different release may cover features or syntax that either don't appear on 1Z0-082 or behave differently than what's tested.

For candidates trying to plan a study or testing timeline around work, travel, or other certifications, our OCA Exam Dates 2026: Testing Windows, Deadlines & Scheduling page covers scheduling mechanics in more detail, and OCA Certification Cost 2026: Complete Pricing Breakdown breaks down the fee structure so there are no surprises when you register.

The 23 Domains You'll Be Tested On

1Z0-082 doesn't test one narrow skill - it spans 23 domains that move between database architecture, security administration, storage management, and SQL querying. Understanding the shape of these domains before you start studying will save you from over-preparing on topics that get light coverage and under-preparing on the ones that carry real weight in the exam room.

The SQL-heavy side of the exam is substantial and includes domains like Restricting and Sorting Data, Displaying Data from Multiple Tables Using Joins, Using Subqueries to Solve Queries, Using Single-Row Functions to Customize Output, Using Conversion Functions and Conditional Expressions, Using SET Operators, and Reporting Aggregated Data Using Group Functions. If your SQL fundamentals are rusty, this cluster alone can determine whether you pass.

On the administration side, expect coverage of Managing Tablespaces and Datafiles, Managing Storage, Managing Undo, Configuring Oracle Net Services, and Moving Data - plus schema-object topics like Managing Sequences, Synonyms, Indexes, Managing Views, Managing Schema Objects, and Managing Tables using DML statements. Rounding out the list are Understanding Data Definition Language, Managing Data in Different Time Zones, Accessing an Oracle Database with Oracle supplied Tools, and Retrieving Data using the SQL SELECT Statement.

For a domain-by-domain breakdown with more detail on what each area covers and how heavily it tends to appear, our companion guide, OCA Exam Domains 2026: Complete Guide to All 23 Content Areas, is the natural next stop after this article.

How 1Z0-082 Fits the Certified Professional Path

This is the part of the story that gets lost when people casually call 1Z0-082 "the OCA exam" without context: passing it doesn't produce a finished certification on its own. It's Step 1 of the Oracle Database Administration 2019 Certified Professional path. Step 2 is exam 1Z0-083, which builds on the administration skills introduced in 1Z0-082.

Oracle also allows candidates to satisfy Step 1 with a newer alternative: the Oracle Database 23ai Administration Associate credential. Either route - 1Z0-082 or the 23ai Associate exam - gets you to the same Step 1 checkpoint before moving on to 1Z0-083.

Choosing which Step 1 exam to take often comes down to which database version you already work with day to day, or which version your target employer runs. Either way, the practical implication is the same: passing 1Z0-082 is a milestone toward the full Certified Professional credential, not the finish line. This distinction matters when you're evaluating OCA Certification claims or comparing your progress against job postings that reference the full professional-level credential rather than a single exam.

If you're still mapping out terminology and want the plainer definitions side of things, our related explainers - OCA Meaning, What Does OCA Stand For?, and What Is OCA Certification? - cover the naming questions without repeating the exam-mechanics detail found here.

Who Actually Hires for This Skill Set

The domains tested on 1Z0-082 line up closely with tasks performed by junior and mid-level database administrators, database support engineers, and application developers who need to work directly with an Oracle database rather than through an abstraction layer. Employers running Oracle Database in production - in industries like finance, healthcare, telecom, and government IT - tend to value hands-on familiarity with the exact tasks the exam covers: user and privilege management, tablespace administration, instance startup/shutdown procedures, and SQL querying against real schemas.

Because the exam is scoped to 19c specifically, it signals current, practical knowledge rather than outdated familiarity with much older releases. That said, the credential itself is one input among several that hiring managers weigh - alongside actual production experience, familiarity with backup and recovery procedures (covered more in 1Z0-083), and general SQL fluency.

If you're trying to gauge how this fits into a broader career or compensation picture, our OCA Salary Guide 2026: Complete Earnings Analysis and OCA Jobs pages go into more detail on role types and how this exam typically factors into hiring conversations.

Mapping a Study Plan to the Domains

Generic study advice - timers, flashcards, spaced repetition - only helps if it's applied against the actual shape of this exam. Given that 1Z0-082 splits fairly evenly between architecture/administration domains and SQL-querying domains, a sensible allocation is to treat those as two separate study tracks rather than one continuous list of 23 items.

For a fuller week-by-week plan with pacing guidance, our OCA Study Guide 2026: How to Pass on Your First Attempt article expands on this structure, and running timed sets on our practice test platform is one of the more direct ways to confirm you can complete all 72 questions inside the 120-minute window before exam day. You can also cross-check your weak domains against the pass-rate discussion in OCA Pass Rate 2026: What the Data Shows to prioritize where extra review time goes.

Frequently Asked Questions