- What 1Z0-082 Actually Tests
- The Two Domain Families You Need to Master
- Database Administration Domains (1-9)
- SQL and Data Handling Domains (10-23)
- Which Domains Matter Most
- Sequencing 23 Domains Into a Study Plan
- Where Candidates Lose Points
- Who Actually Uses This Domain Knowledge
- Frequently Asked Questions
- 1Z0-082 covers 23 domains split between database administration tasks and SQL fundamentals.
- The exam has 72 questions in 120 minutes, and 60% is the passing threshold.
- Content is validated against Oracle Database 19c, so lab practice should target that version.
- 1Z0-082 sits at Step 1 of the Oracle Database Administration 2019 Certified Professional path, followed by 1Z0-083.
What 1Z0-082 Actually Tests
Oracle Database Administration I (1Z0-082) is administered by Oracle Corporation through Oracle University, and it is the exam most people mean when they search for information about this credential. The format is straightforward on paper: 72 multiple-choice questions, 120 minutes on the clock, and a 60% passing score. What makes the exam demanding isn't the format - it's the breadth. Oracle organizes the content into 23 distinct domains that swing between hands-on database administration and SQL query writing, and the exam is validated against Oracle Database 19c, which should be your reference version for every lab exercise.
Before diving into the domains themselves, it helps to understand where this exam fits. 1Z0-082 is Step 1 of the Oracle Database Administration 2019 Certified Professional path, and Oracle now also accepts the newer Oracle Database 23ai Administration Associate credential at that same step, with 1Z0-083 completing the path either way. If you're still sorting out prerequisites and path mechanics, the OCA Requirements guide walks through eligibility in more detail, and our OCA Study Guide covers first-attempt strategy beyond just domain content.
The Two Domain Families You Need to Master
The fastest way to make sense of 23 domains is to notice they cluster into two families. The first family is pure database administration: architecture, instances, storage, users, and networking. The second family is SQL: writing queries, joins, functions, subqueries, and schema objects. A candidate who is strong in one family and weak in the other will feel the exam is uneven - confident on some question blocks, guessing on others. That imbalance is one of the most common reasons people underestimate difficulty going in; the How Hard Is the OCA Exam breakdown digs into why this dual nature catches candidates off guard.
Treat both families as equally exam-critical, even though your day-to-day job might lean toward one or the other. The multiple-choice format means every domain, no matter how narrow it sounds, can appear as a scored question.
Database Administration Domains (1-9)
These nine domains form the operational core of the exam - the tasks a working Oracle DBA performs to keep an instance healthy, secure, and accessible.
Domain 1: Understanding Oracle Database Architecture
Covers the memory structures, background processes, and physical/logical storage relationships that everything else in the exam builds on.
- Know the SGA, PGA, and background process roles cold before touching other domains.
Domain 2: Managing Users, Roles and Privileges
Tests your ability to create accounts, assign roles, and grant or revoke system and object privileges correctly.
- Distinguish system privileges from object privileges - a frequent trap in distractor answers.
Domain 3: Moving Data
Focuses on Oracle's data movement utilities and the scenarios where each tool applies.
- Know which tool fits full exports vs. targeted table-level moves.
Domain 4: Accessing an Oracle Database with Oracle Supplied Tools
Covers SQL*Plus, SQL Developer, and other Oracle-provided interfaces used for administration and querying.
Domain 5: Managing Tablespaces and Datafiles
Requires understanding how logical tablespaces map to physical datafiles, and how to resize, add, or take them offline safely.
Domain 6: Managing Database Instances
Covers startup/shutdown modes, parameter files, and instance-level configuration.
Domain 7: Managing Storage
Extends beyond tablespaces into broader storage structures and allocation behavior.
Domain 8: Configuring Oracle Net Services
Tests listener configuration and how clients connect to the database over the network - a domain candidates often under-prepare for.
Domain 9: Managing Undo
Covers undo tablespace behavior, retention, and how Oracle uses undo data for read consistency and rollback.
SQL and Data Handling Domains (10-23)
The remaining fourteen domains shift into SQL fundamentals - reading, filtering, joining, and shaping data, plus the schema objects that support it.
Domain 10: Restricting and Sorting Data
WHERE clause logic, comparison operators, and ORDER BY behavior.
Domain 11: Displaying Data from Multiple Tables Using Joins
Inner, outer, self, and cross joins - one of the heaviest-tested SQL domains on the exam.
- Practice writing joins without relying on auto-suggest in an IDE.
Domain 12: Understanding Data Definition Language
CREATE, ALTER, and DROP statement behavior for tables and constraints.
Domain 13: Managing Data in Different Time Zones
Date/time data types and time zone-aware functions, a domain frequently underestimated in scope.
Domain 14: Using Single-Row Functions to Customize Output
Character, number, and date functions applied row by row.
Domain 15: Using Subqueries to Solve Queries
Single-row, multi-row, and correlated subqueries embedded in SELECT, WHERE, and FROM clauses.
Domain 16: Managing Sequences, Synonyms, Indexes
Object creation and maintenance for three distinct schema helper objects.
Domain 17: Using Conversion Functions and Conditional Expressions
Explicit/implicit conversion and CASE-style logic in SQL.
Domain 18: Using SET Operators
UNION, UNION ALL, INTERSECT, and MINUS behavior and column-matching rules.
Domain 19: Managing Views
Simple vs. complex views and which DML operations a view supports.
Domain 20: Retrieving Data using the SQL SELECT Statement
Core SELECT syntax - the foundation domain nearly every other SQL domain builds on.
Domain 21: Reporting Aggregated Data Using Group Functions
GROUP BY, HAVING, and aggregate function edge cases.
Domain 22: Managing Tables using DML statements
INSERT, UPDATE, DELETE, and transaction control basics.
Domain 23: Managing Schema Objects
Constraints, object dependencies, and schema-level object management pulling together prior SQL domains.
Which Domains Matter Most
Oracle does not publish exact per-domain scoring weights for 1Z0-082, so avoid trusting any source that claims precise percentages - treat all 23 domains as fair game. What you can do is prioritize by breadth and dependency: domains that other domains build on deserve more study time.
| Domain Group | Approx. Domain Count | Study Priority Reasoning |
|---|---|---|
| Core Architecture & Instances (Domains 1, 6, 7, 9) | 4 | Foundational - nearly every other DBA domain references these concepts |
| Security & Access (Domains 2, 4, 8) | 3 | Frequently scenario-based question style |
| Storage Management (Domains 3, 5) | 2 | Practical, tool-driven questions |
| Core SQL Retrieval (Domains 10, 11, 20, 21) | 4 | Heaviest concentration of SQL questions |
| SQL Objects & Functions (Domains 12-19, 22, 23) | 10 | Wide but shallower coverage per topic |
If you want a condensed version of the highest-yield facts across all 23 domains for last-minute review, the OCA Cheat Sheet is built specifically for that pass.
Sequencing 23 Domains Into a Study Plan
With 23 domains, sequencing matters more than raw hours studied. Front-load architecture concepts because they explain the "why" behind instance management, storage, and undo. Save joins and subqueries for a stretch of consecutive days rather than isolated sessions, since SQL logic compounds quickly.
Architecture & Foundations
- Domain 1: Understanding Oracle Database Architecture
- Domain 6: Managing Database Instances
- Domain 9: Managing Undo
Storage, Access & Networking
- Domain 5: Managing Tablespaces and Datafiles
- Domain 7: Managing Storage
- Domain 8: Configuring Oracle Net Services
- Domain 2: Managing Users, Roles and Privileges
Core SQL Retrieval
- Domain 20: Retrieving Data using the SQL SELECT Statement
- Domain 10: Restricting and Sorting Data
- Domain 11: Displaying Data from Multiple Tables Using Joins
- Domain 21: Reporting Aggregated Data Using Group Functions
SQL Depth & Schema Objects
- Domain 15: Using Subqueries to Solve Queries
- Domain 16: Managing Sequences, Synonyms, Indexes
- Domain 19: Managing Views
- Domain 22 & 23: DML and Schema Objects
This sequencing pairs well with lighter-touch techniques like timed recall drills or short daily review blocks - just anchor them to the specific domain you covered that week rather than generic flashcard cycling. For a fuller first-attempt framework, see the OCA Study Guide.
Where Candidates Lose Points
Key Takeaway
Passing requires only 60%, but with 23 domains in scope, a candidate can't selectively skip entire domain groups and still comfortably clear that bar. Distribute study time across both the administration and SQL families.
Who Actually Uses This Domain Knowledge
The 23 domains map closely to what junior and mid-level Oracle database administrators do in production environments: provisioning users, managing storage growth, troubleshooting connectivity, and writing the SQL needed to investigate or fix issues. Organizations running Oracle Database still rely on staff who can move fluidly between administration tasks and SQL work, which is exactly the dual skill set this exam validates. If you're evaluating how this credential fits into a hiring pipeline, our OCA Jobs resource looks at the kinds of roles that reference this exam, and Is the OCA Certification Worth It? covers the broader ROI conversation.
Once you've mapped all 23 domains against your own experience, running full-length practice exams on our practice test platform is the most reliable way to see which domains still need work before exam day. Timed, domain-tagged practice on the main practice site also helps simulate the 120-minute pressure of the real 72-question format.
Frequently Asked Questions
Oracle does not publish exact per-domain weighting, so it's safest to prepare all 23 domains thoroughly rather than assume any are minor. See the OCA Passing Score guide for how the 60% threshold applies across the exam as a whole.
Since domains split between database administration (1-9) and SQL fundamentals (10-23), candidates strong in only one family typically struggle on the other half of the exam.
1Z0-082 is validated against Oracle Database 19c, so lab environments and practice queries should target that version for the most accurate preparation.
It serves as Step 1 of the Oracle Database Administration 2019 Certified Professional path (or can be substituted with the Oracle Database 23ai Administration Associate credential), followed by 1Z0-083.
Start with foundational architecture and core SELECT statement concepts, since most other domains build on them; the OCA Study Guide outlines a full sequencing approach.