- 1Z0-082 has 72 multiple-choice questions, a 120-minute limit, and a 60% passing score, validated against Oracle Database 19c.
- The exam spans 23 domains split roughly between database administration and SQL fundamentals.
- 1Z0-082 is not a standalone credential - it's Step 1 of the Oracle Database Administration 2019 Certified Professional path, paired with 1Z0-083.
- Oracle recommends familiarity with Oracle Database, DBA concepts, and SQL fundamentals before sitting the exam.
Exam Snapshot: The Numbers You Must Memorize
Before you touch a single practice question, lock in the mechanics of Oracle Database Administration I (1Z0-082). This is the number one page candidates print out and tape next to their monitor the week before test day.
- Format: 72 multiple-choice questions
- Time limit: 120 minutes
- Passing score: 60%
- Database version tested: Oracle Database 19c
- Administered by: Oracle Corporation through Oracle University
- Recommended background: experience with Oracle Database, database administration concepts, and SQL fundamentals
If you want the full breakdown of how that 60% threshold translates into a raw score, review the dedicated OCA Passing Score 2026 guide. And if you're still deciding whether the difficulty level matches your current SQL and DBA experience, the How Hard Is the OCA Exam? guide walks through that in more depth than this one-pager can.
Registration and Path Basics
1Z0-082 sits at the front of a two-exam professional path. Step 1 can be satisfied with either 1Z0-082 or the newer Oracle Database 23ai Administration Associate credential, and Step 2 is completed with 1Z0-083. That means candidates who started studying 19c-era material and candidates on the newer 23ai track both converge on the same professional certification once they finish 1Z0-083.
For a full walkthrough of prerequisites, recommended experience, and how the two-step structure works in practice, see OCA Requirements 2026: Eligibility, Prerequisites & How to Qualify. If your priority right now is scheduling logistics rather than content, the OCA Exam Dates 2026 guide and the OCA Certification Cost 2026 breakdown cover testing windows and pricing mechanics without repeating exam-content details already on this page.
The 23 Domains at a Glance
1Z0-082 is built from 23 domains. Roughly ten focus on hands-on database administration, and thirteen focus on SQL. Skimming the full list before you start deep review helps you spot which domains sound unfamiliar and need more time.
Administration-Focused Domains
- Domain 1: Understanding Oracle Database Architecture
- Domain 2: Managing Users, Roles and Privileges
- Domain 3: Moving Data
- Domain 4: Accessing an Oracle Database with Oracle Supplied Tools
- Domain 5: Managing Tablespaces and Datafiles
- Domain 6: Managing Database Instances
- Domain 7: Managing Storage
- Domain 8: Configuring Oracle Net Services
- Domain 9: Managing Undo
- Domain 23: Managing Schema Objects
SQL-Focused Domains
- Domain 10: Restricting and Sorting Data
- Domain 11: Displaying Data from Multiple Tables Using Joins
- Domain 12: Understanding Data Definition Language
- Domain 13: Managing Data in Different Time Zones
- Domain 14: Using Single-Row Functions to Customize Output
- Domain 15: Using Subqueries to Solve Queries
- Domain 16: Managing Sequences, Synonyms, Indexes
- Domain 17: Using Conversion Functions and Conditional Expressions
- Domain 18: Using SET Operators
- Domain 19: Managing Views
- Domain 20: Retrieving Data using the SQL SELECT Statement
- Domain 21: Reporting Aggregated Data Using Group Functions
- Domain 22: Managing Tables using DML statements
For a domain-by-domain expansion with subtopics, sample scenarios, and study angles beyond this condensed version, use the OCA Exam Domains 2026: Complete Guide to All 23 Content Areas.
Administration Domain Quick Facts
These are the facts candidates most often forget under time pressure. Treat this as your rapid-fire recall list.
Domain 1: Architecture
Know the relationship between an instance and a database, memory structures (SGA, PGA), and background processes. This domain underlies almost every later question, even ones nominally about storage or undo.
- Instance = memory + background processes; database = physical files
- Know which structures live in the SGA vs. the PGA
Domain 6: Managing Database Instances
Startup and shutdown modes, parameter files, and diagnostic destinations are tested with precise wording - memorize the exact sequence of startup stages (NOMOUNT, MOUNT, OPEN).
- Distinguish SHUTDOWN NORMAL, IMMEDIATE, TRANSACTIONAL, and ABORT
Domain 5 & 7: Tablespaces, Datafiles, and Storage
Expect questions on creating tablespaces, resizing datafiles, and choosing between locally managed and dictionary-managed storage concepts, plus extent and segment management.
Domain 9: Managing Undo
Undo tablespaces, undo retention, and how undo supports read consistency and flashback operations are consistently tested - this is a domain where conceptual gaps show up fast on exam day.
Domain 2: Users, Roles and Privileges
Object privileges vs. system privileges, role hierarchies, and profile-based password/resource limits are all fair game. Practice writing the exact GRANT and REVOKE syntax rather than just recognizing it.
SQL Domain Quick Facts
Thirteen of the twenty-three domains are SQL-centered, so weak SQL fundamentals will cost more points than weak DBA trivia. Prioritize fluency, not just recognition, in these areas.
Domain 20: Retrieving Data using the SQL SELECT Statement
The baseline for everything else - column aliasing, arithmetic expressions, concatenation, and DISTINCT usage.
Domain 11: Displaying Data from Multiple Tables Using Joins
Inner joins, outer joins (LEFT/RIGHT/FULL), self-joins, and Cartesian products. Know when a missing join condition silently produces wrong results rather than an error.
Domain 15: Using Subqueries to Solve Queries
Single-row vs. multiple-row subqueries, correlated subqueries, and the operators that pair with each (=, IN, ANY, ALL, EXISTS).
Domain 21: Reporting Aggregated Data Using Group Functions
GROUP BY and HAVING logic, including why aggregate functions can't appear in a WHERE clause and how NULL values are handled by COUNT, AVG, and SUM.
Domains 12, 16, 19, 22, 23: DDL, Schema Objects, and Data Manipulation
CREATE, ALTER, DROP for tables, views, indexes, sequences, and synonyms; DML statements (INSERT, UPDATE, DELETE, MERGE); and the implications of committing versus rolling back a transaction.
Key Takeaway
If you can only review two domain clusters the night before the exam, choose Architecture (Domain 1) because it underpins later admin questions, and Joins plus Subqueries (Domains 11 and 15) because SQL logic errors are the most common source of missed points.
SQL vs. Administration: Where Points Actually Live
Because 1Z0-082 blends DBA tasks with SQL querying, candidates coming from a pure development background or a pure operations background often assume their existing skills cover more of the exam than they actually do.
| Area | Domain Count | Typical Weak Spot |
|---|---|---|
| Database Administration | 10 domains (1-9, 23) | Architecture terminology, undo/redo distinctions, exact startup/shutdown syntax |
| SQL Fundamentals | 13 domains (10-22) | Multi-table joins, subquery types, group function edge cases with NULLs |
Neither side of the exam can be skipped - a candidate strong in SQL but shaky on tablespace and undo concepts will still miss a meaningful share of questions, and vice versa. If you're unsure how your background stacks up against the exam's expectations, the OCA Study Guide 2026 outlines how to self-assess before committing to a full study plan.
Last-Mile Review Timeline
This cheat sheet isn't a full study plan - that's what the study guide above is for - but a short, domain-anchored review sequence helps in the final stretch before your scheduled attempt.
Architecture and Instance Management
- Redraw the instance/database diagram from memory (Domain 1)
- Drill startup/shutdown modes and parameter files (Domain 6)
Storage, Undo, and Security
- Practice tablespace and datafile commands (Domains 5, 7)
- Review undo retention and read-consistency scenarios (Domain 9)
- Write GRANT/REVOKE statements from scratch (Domain 2)
Core SQL Retrieval and Joins
- Time yourself on SELECT, WHERE, ORDER BY questions (Domains 10, 20)
- Practice every join type on paper before checking syntax (Domain 11)
Subqueries, Functions, and Final Simulation
- Work correlated and multi-row subqueries (Domain 15)
- Review single-row and group functions, conversions (Domains 14, 17, 21)
- Run a full 72-question, 120-minute timed simulation on our practice test platform
Common Traps on Exam Day
These are the recurring reasons candidates lose points that they clearly knew the material for:
- Confusing similar syntax: ALTER TABLE vs. ALTER TABLESPACE questions are easy to misread under time pressure.
- Ignoring NULL behavior: Aggregate functions, joins, and comparison operators all treat NULL differently - the exam exploits this repeatedly.
- Mixing up privilege types: System privileges control actions; object privileges control access to specific schema objects. Domain 2 questions hinge on this distinction.
- Running out of time on long SQL statements: With 72 questions in 120 minutes, you have under two minutes per question on average - don't over-analyze multi-table query questions.
- Skipping practice under real conditions: Reading about joins and writing joins under a countdown timer are different skills. Use full-length runs on the practice test site to close that gap before test day.
What Comes After 1Z0-082
Passing 1Z0-082 is Step 1 of the Oracle Database Administration 2019 Certified Professional path - it isn't the finish line. Step 2 requires passing 1Z0-083, which builds on the administration domains covered here (particularly instance management, storage, and undo) with deeper backup, recovery, and performance topics. Some candidates instead complete Step 1 with the newer Oracle Database 23ai Administration Associate credential, but both routes converge on the same 1Z0-083 requirement.
If you're evaluating whether the full professional path is worth the time investment relative to the roles it opens up, the Is the OCA Certification Worth It? Complete ROI Analysis 2026 article and the OCA Jobs overview both dig into that question without repeating the domain-level content covered here.
FAQ
The exam has 72 multiple-choice questions with a 120-minute time limit, giving you roughly 100 seconds per question on average.
You need 60% to pass. See the OCA Passing Score 2026 guide for how that percentage maps to correct answers out of 72.
The exam is validated against Oracle Database 19c, so study materials and hands-on practice should reflect 19c behavior.
No. It is Step 1 of the Oracle Database Administration 2019 Certified Professional path, and it must be paired with 1Z0-083 (or an equivalent Step 1 credential like Oracle Database 23ai Administration Associate) to complete that professional certification.
Oracle recommends experience with Oracle Database, database administration concepts, and SQL fundamentals, though the exact eligibility mechanics are covered in the OCA Requirements 2026 guide.