- What "OCA Certification" Actually Means for 1Z0-082
- Exam Format and Registration Mechanics
- The 23 Domains That Define the Exam
- Database Administration Domains vs. SQL Domains
- Who Actually Hires for This Credential
- Sequencing Your Study Around the Domains
- Where 1Z0-082 Fits in the Certified Professional Path
- Frequently Asked Questions
- 1Z0-082 has 72 multiple-choice questions, a 120-minute limit, and a 60% passing score.
- The exam is validated against Oracle Database 19c and spans 23 distinct content domains.
- 1Z0-082 is Step 1 of the Oracle Database Administration 2019 Certified Professional path, followed by 1Z0-083.
- Candidates can also satisfy Step 1 with the newer Oracle Database 23ai Administration Associate credential.
What "OCA Certification" Actually Means for 1Z0-082
Search for "OCA certification" and you'll find several unrelated credentials from different industries competing for the same three letters. On this site, and in this article specifically, OCA refers to Oracle Database Administration I (1Z0-082), administered by Oracle Corporation through Oracle University. It is worth being precise here: 1Z0-082 is not marketed by Oracle as a standalone "OCA" credential in the current catalog - that naming convention belongs to an earlier generation of Oracle certifications. Today, 1Z0-082 functions as the first step of the Oracle Database Administration 2019 Certified Professional path, which is completed by passing a second exam, 1Z0-083.
That distinction matters for how you plan your prep. If you're targeting the DBA professional path, 1Z0-082 is not a finish line - it's a checkpoint. Oracle also allows candidates to satisfy the first step of that path with the newer Oracle Database 23ai Administration Associate credential instead of 1Z0-082, so anyone comparing exam options should be clear about which version they're sitting. For readers who want the full breakdown of terminology confusion around this acronym, see our companion pieces on What Is OCA?, OCA Meaning, and What Does OCA Stand For? - each untangles a different angle of the naming question so you don't waste study time on the wrong material.
Exam Format and Registration Mechanics
1Z0-082 is a multiple-choice exam delivered through Oracle University's testing infrastructure. The mechanics are straightforward:
- 72 questions presented in multiple-choice format
- 120 minutes total time allotted
- 60% required to pass
- Content validated against Oracle Database 19c
Oracle recommends that candidates come in with practical exposure to Oracle Database, familiarity with database administration concepts, and a working grasp of SQL fundamentals. None of this is formally gatekept - there's no mandatory training course or prerequisite exam you must clear before registering - but the recommendation reflects the exam's actual difficulty. Questions assume you've touched a live database instance, not just read about one. For a full walkthrough of eligibility expectations, see OCA Requirements 2026: Eligibility, Prerequisites & How to Qualify, and for the pricing side of registration, check OCA Certification Cost 2026: Complete Pricing Breakdown.
Because the format is fixed at 72 questions in a strict 120-minute window, pacing is a real factor - you have under two minutes per question on average, and SQL syntax questions can eat that time quickly if you're not fluent. If you want a deeper look at how that time pressure translates into perceived difficulty, our How Hard Is the OCA Exam? Complete Difficulty Guide 2026 article breaks this down domain by domain.
Key Takeaway
Treat the 60% passing threshold as a floor, not a target. Because the exam is validated against 19c specifically, verify that any study material or practice questions you use match that version rather than an older or newer release.
The 23 Domains That Define the Exam
1Z0-082 doesn't test "Oracle DBA skills" as a vague blob - it's built from 23 named domains, and each one maps to specific tasks a DBA performs on a real system. Understanding the full list before you start studying prevents the common mistake of over-preparing on SQL syntax while under-preparing on architecture and storage - or vice versa.
Domain 1: Understanding Oracle Database Architecture
Foundational knowledge of instance memory structures, background processes, and how the database physically and logically organizes data.
- Instance vs. database distinction
- Memory structures (SGA, PGA)
- Background process roles
Domain 6: Managing Database Instances
Startup and shutdown sequences, parameter files, and diagnostic data are core to this domain - and frequently tested with scenario-based questions.
- Startup/shutdown modes
- Parameter file management
- Alert log and diagnostic destinations
Domain 5: Managing Tablespaces and Datafiles
Candidates must know how to create, resize, and manage tablespaces and their underlying datafiles, including different tablespace types.
- Bigfile vs. smallfile tablespaces
- Autoextend behavior
- Default vs. temporary tablespace assignment
Domain 9: Managing Undo
Undo tablespace configuration and retention behavior often appear alongside recovery-related scenario questions.
- Automatic undo management
- Undo retention guarantees
- Relationship between undo and read consistency
The remaining domains fill out both the administrative and SQL sides of the job: Managing Users, Roles and Privileges; Moving Data; Accessing an Oracle Database with Oracle Supplied Tools; Managing Storage; Configuring Oracle Net Services; Restricting and Sorting Data; Displaying Data from Multiple Tables Using Joins; Understanding Data Definition Language; Managing 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; Retrieving Data Using the SQL SELECT Statement; Reporting Aggregated Data Using Group Functions; Managing Tables Using DML Statements; and Managing Schema Objects. For an item-by-item breakdown of what each domain actually tests, see OCA Exam Domains 2026: Complete Guide to All 23 Content Areas.
Database Administration Domains vs. SQL Domains
A useful way to mentally group the 23 domains is by skill category - this shapes how you allocate study time, since the two skill sets require different practice methods (hands-on database work vs. query writing).
| Category | Representative Domains | Study Approach |
|---|---|---|
| Core Architecture & Administration | Understanding Oracle Database Architecture; Managing Database Instances; Managing Undo; Configuring Oracle Net Services | Requires a running instance to observe processes and configuration files firsthand |
| Storage & Security | Managing Tablespaces and Datafiles; Managing Storage; Managing Users, Roles and Privileges | Practice creating, altering, and monitoring objects with real SQL commands |
| Data Movement & Tools | Moving Data; Accessing an Oracle Database with Oracle Supplied Tools | Familiarity with export/import and Oracle-supplied utilities matters more than memorization |
| SQL Query & Schema Skills | Retrieving Data Using SQL SELECT; Joins; Subqueries; Group Functions; SET Operators; Managing Views; Managing Schema Objects; DDL; DML | Write and run queries repeatedly rather than just reading syntax references |
Who Actually Hires for This Credential
Because 1Z0-082 sits at the entry point of Oracle's DBA professional path, it's most relevant to people already working with, or transitioning into, database-facing roles: junior database administrators, application support engineers who maintain Oracle-backed systems, SQL developers moving toward operational DBA work, and IT staff at organizations running Oracle Database as core infrastructure. It's rarely the sole qualifying factor in a hiring decision, but it's commonly used as a screening signal alongside hands-on experience. If you're evaluating whether this credential is worth pursuing relative to your career goals, Is the OCA Certification Worth It? Complete ROI Analysis 2026 walks through the tradeoffs, and OCA Jobs surveys the kinds of roles that reference it in postings.
The domain content itself is a strong clue about the job: heavy coverage of tablespaces, undo, instance management, and Oracle Net Services signals that Oracle expects certified candidates to actually operate a database, not just query it. That's a meaningful distinction from certifications that focus purely on SQL or purely on cloud tooling.
Sequencing Your Study Around the Domains
Generic study techniques - spaced repetition, timed practice blocks, active recall - only help if they're applied to the right material at the right time. Given the split between architecture/administration domains and SQL domains, a sequencing approach that groups similar domains together tends to work better than studying them in numerical order.
Architecture and Instance Fundamentals
- Understanding Oracle Database Architecture
- Managing Database Instances
- Managing Tablespaces and Datafiles
- Managing Storage
Security, Undo, and Networking
- Managing Users, Roles and Privileges
- Managing Undo
- Configuring Oracle Net Services
- Moving Data and Oracle-supplied tools
Core SQL Retrieval Skills
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Joins across multiple tables
- Group functions and aggregation
Schema Objects and Exam Simulation
- DDL, DML, views, sequences, synonyms, indexes
- Subqueries, SET operators, conversion functions
- Full-length timed practice under 120-minute constraints
Whatever pace you follow, build in full-length practice attempts that mirror the 72-question, 120-minute format rather than only doing untimed domain drills - pacing failures are a common reason candidates miss the 60% mark despite knowing the material. Our OCA Study Guide 2026: How to Pass on Your First Attempt covers this in more depth, and you can run realistic timed sessions on the main practice test platform to calibrate your speed before exam day. A quick-reference summary of the highest-yield facts across all 23 domains is also available in the OCA Cheat Sheet 2026: One-Page Review of Must-Know Facts.
Where 1Z0-082 Fits in the Certified Professional Path
1Z0-082 is Step 1 of the Oracle Database Administration 2019 Certified Professional path. Step 2 is 1Z0-083, which builds on the administration and SQL foundation established in the first exam. Oracle also permits candidates to complete Step 1 via the newer Oracle Database 23ai Administration Associate credential instead of 1Z0-082 - meaning there are now two valid entry routes into the same professional-level outcome. If your goal is the full Certified Professional designation, plan your study timeline around both exams rather than treating 1Z0-082 as a terminal achievement.
Understanding exactly what "passing" requires - and how that score is calculated against the 72-question format - is worth reviewing in detail before you schedule anything; see OCA Passing Score 2026: Exactly What You Need to Pass. And if scheduling logistics, testing windows, or deadlines are your next question, OCA Exam Dates 2026: Testing Windows, Deadlines & Scheduling covers what to expect when you book through Oracle University.
For a broader orientation to the terminology confusion that surrounds this acronym across different industries, our related explainers - What Is A OCA?, What Does OCA Mean?, and What Is OCA Certification? - are useful starting points before you commit to a study plan, and OCA Training outlines preparation resource options once you've confirmed 1Z0-082 is the right target.
Frequently Asked Questions
No. In Oracle's current catalog, 1Z0-082 functions as Step 1 of the Oracle Database Administration 2019 Certified Professional path, completed by also passing 1Z0-083, rather than as an independent "OCA" credential.
The exam contains 72 multiple-choice questions with a 120-minute time limit, and you need 60% correct to pass.
1Z0-082 is validated against Oracle Database 19c, so study materials should be checked against that version.
Yes. Oracle allows the Oracle Database 23ai Administration Associate credential to satisfy Step 1 of the same professional path in place of 1Z0-082, followed by 1Z0-083.
Oracle does not publish per-domain weightings for 1Z0-082, so candidates should prepare across all 23 domains rather than assuming any single area dominates the question pool.