- Are There Formal Prerequisites?
- Who Can Register for 1Z0-082
- Recommended Background Knowledge
- Exam Format You Need to Meet
- Domain-by-Domain Readiness Checklist
- Registration and Scheduling Mechanics
- How 1Z0-082 Fits the Certified Professional Path
- Turning Requirements Into a Study Plan
- Frequently Asked Questions
- 1Z0-082 has no mandatory prerequisite courses - Oracle only recommends prior database and SQL experience.
- The exam is 72 questions in 120 minutes, validated against Oracle Database 19c, with a 60% passing score.
- 1Z0-082 covers 23 distinct domains spanning architecture, administration, and SQL.
- 1Z0-082 works as Step 1 of the Oracle Database Administration 2019 Certified Professional path, alongside the newer 23ai Associate option.
Are There Formal Prerequisites?
If you're searching for a gatekeeping requirement - a degree, a minimum number of years in IT, a mandatory bootcamp - you won't find one for exam 1Z0-082 (Oracle Database Administration I). Oracle does not require candidates to complete a specific training course, submit work history, or hold a prior certification before sitting the exam. There is no application form to approve, no interview, and no committee reviewing your resume.
What Oracle does publish are recommendations, not requirements. Oracle recommends candidates have experience with Oracle Database itself, familiarity with database administration concepts, and a working grasp of SQL fundamentals. That distinction matters: you are legally and administratively free to register the moment you decide to, but whether you'll actually pass without that background is a separate question entirely - one covered in depth in our guide on how hard the OCA exam really is.
Who Can Register for 1Z0-082
Because there's no eligibility screening, registration is functionally open to anyone willing to pay the exam fee and pick a testing slot through Oracle University. That includes:
- College students studying computer science or information systems who want a credential before graduating.
- Junior IT staff - help desk, systems admin, junior developers - pivoting toward database work.
- Experienced professionals in other database platforms (SQL Server, MySQL, PostgreSQL) transitioning to Oracle environments.
- Self-taught learners who have practiced SQL and basic administration tasks independently.
The absence of formal eligibility rules doesn't mean the exam is easy to pass without preparation - it means the "requirement" is really a self-assessment exercise. For a realistic picture of where candidates actually stand after attempting the exam, see our breakdown in OCA Pass Rate 2026: What the Data Shows.
Recommended Background Knowledge
Oracle's recommended background boils down to three pillars. Treat these as your real prerequisites, even though they aren't enforced at registration:
1. Oracle Database Experience
Hands-on exposure to an actual Oracle Database instance - installing it, connecting to it, running basic commands - makes the architecture and instance-management domains far less abstract.
- Comfort with SQL*Plus or SQL Developer as a client tool
- Basic familiarity with the Oracle Database 19c release, since the exam is validated against that version
2. Database Administration Concepts
You should be able to reason about how a database instance is structured and maintained, not just how to write queries against it.
- Understanding memory structures, background processes, and storage at a conceptual level
- Familiarity with tasks like managing tablespaces, datafiles, and undo
3. SQL Fundamentals
A large share of the exam content is SQL-centric, so this pillar carries disproportionate weight.
- Writing and restricting SELECT statements
- Using joins, subqueries, group functions, and conversion functions confidently
If you're unsure how deep your SQL needs to go before attempting the exam, our OCA Study Guide 2026: How to Pass on Your First Attempt walks through a sequencing strategy that builds SQL skill before layering on administration topics.
Exam Format You Need to Meet
Beyond knowledge prerequisites, there are format-based requirements you need to be ready for on exam day itself. These are fixed by Oracle and don't vary by candidate:
| Requirement | Detail |
|---|---|
| Question count | 72 multiple-choice questions |
| Time limit | 120 minutes |
| Passing score | 60% |
| Database version validated | Oracle Database 19c |
| Administered by | Oracle University |
That works out to roughly 100 seconds per question on average, though question difficulty is not evenly distributed - some SQL syntax questions are answered in seconds, while multi-step architecture or privilege-management scenarios take longer. For the exact scoring mechanics and why 60% is the threshold you're aiming for, see OCA Passing Score 2026: Exactly What You Need to Pass.
Key Takeaway
Meeting the "requirement" of finishing 72 questions in 120 minutes is a pacing skill, not just a knowledge skill. Practice under timed conditions well before your scheduled date - our full-length practice tests are built around the same 72-question structure.
Domain-by-Domain Readiness Checklist
Since there's no external body verifying your readiness, you have to self-certify against the actual exam blueprint. 1Z0-082 spans 23 domains, and treating each one as a personal checklist item is the most reliable way to confirm you're truly prepared, not just familiar.
- 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 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
- Domain 23: Managing Schema Objects
Notice that roughly half of these domains are pure SQL (retrieval, joins, subqueries, functions, DML, schema objects) while the other half is administration-focused (architecture, storage, instances, undo, networking). This split is why Oracle's "recommended" SQL fundamentals prerequisite is so important - you can't shortcut around 10+ domains of SQL content. For a domain-by-domain study breakdown with priority guidance, read OCA Exam Domains 2026: Complete Guide to All 23 Content Areas.
Registration and Scheduling Mechanics
Because Oracle University administers 1Z0-082 directly, the practical "requirements" to actually sit the exam are administrative rather than academic:
- Create an Oracle account (CertView/Oracle University profile) to register
- Choose a testing method available through Oracle University's exam delivery partner
- Pay the exam fee at registration
- Arrive with valid identification matching your registration details
Pricing and fee structure change and are best checked against current Oracle University listings - we cover the components to budget for in OCA Certification Cost 2026: Complete Pricing Breakdown. Scheduling windows and how far in advance to book are addressed separately in OCA Exam Dates 2026: Testing Windows, Deadlines & Scheduling, since availability depends on your testing method and region rather than any fixed academic calendar.
How 1Z0-082 Fits the Certified Professional Path
One requirement that's easy to overlook is understanding where 1Z0-082 sits structurally. It is Step 1 of the Oracle Database Administration 2019 Certified Professional path. At that first step, candidates currently have two accepted options: pass 1Z0-082, or pass the newer Oracle Database 23ai Administration Associate exam. Either satisfies Step 1. From there, the path continues with 1Z0-083 as Step 2.
This means the "requirement" question isn't just about eligibility to sit 1Z0-082 - it's about deciding whether 1Z0-082 (tied to Database 19c) or the 23ai-based Associate exam better matches the version of Oracle Database you work with or intend to work with professionally. If your organization runs 19c environments, or if your existing skills are already 19c-oriented, 1Z0-082 is the more direct route. If you're starting fresh in 2026 with newer infrastructure, weigh the 23ai option before committing.
For context on how this fits into hiring conversations, roles that reference this credential typically sit in database administration, junior DBA, or SQL-heavy data roles - details explored further in OCA Jobs and Is the OCA Certification Worth It? Complete ROI Analysis 2026.
Turning Requirements Into a Study Plan
Once you've confirmed you meet the (informal) knowledge prerequisites, the real work is converting 23 domains into a schedule you can actually execute. A simple way to structure this is to group domains by theme and dedicate focused blocks to each, rather than studying them in numerical order.
Architecture and Core SQL Foundations
- Domain 1 (Architecture) alongside Domain 20 (SELECT statements) and Domain 10 (Restricting and Sorting Data)
- Build comfort with SQL*Plus/SQL Developer before adding complexity
Joins, Subqueries, and Functions
- Domains 11, 14, 15, 17, 21 - the analytical core of the SQL portion
- Practice writing queries from scratch, not just reading them
Administration: Storage, Instances, and Undo
- Domains 5, 6, 7, 9 - tablespaces, datafiles, instance management, undo
- Pair reading with hands-on tasks against a real or sandbox instance
Security, Objects, and Full Practice Exams
- Domains 2, 8, 12, 16, 19, 22, 23 - privileges, Net Services, DDL, indexes, views, DML, schema objects
- Run timed 72-question practice sets on our practice test platform to calibrate pacing
This grouping deliberately front-loads SQL because it underpins later administration topics - you can't meaningfully manage tables or schema objects (Domains 22, 23) if the syntax from earlier domains isn't automatic yet. A more detailed week-by-week breakdown tied to each domain's weight and complexity is available in our full study guide, and a condensed reference for last-minute review is in the OCA Cheat Sheet 2026.
Frequently Asked Questions
No. Oracle does not require a degree or any formal academic credential to register for or take 1Z0-082. Registration is open to anyone who pays the exam fee through Oracle University.
It's recommended, not mandatory. Oracle suggests experience with Oracle Database, database administration concepts, and SQL fundamentals, but nothing prevents a self-taught candidate from registering without documented work history.
The exam content is validated against Oracle Database 19c, so practicing against a 19c environment gives you the closest match to what's tested, though core SQL and administration concepts carry across nearby versions.
Yes. Step 1 of the Oracle Database Administration 2019 Certified Professional path accepts either 1Z0-082 or the Oracle Database 23ai Administration Associate exam, followed by 1Z0-083 as Step 2.
Roughly half the domains focus on SQL skills (retrieval, joins, subqueries, functions, DML, schema objects) and the other half on database administration (architecture, storage, instances, undo, networking), so both areas need dedicated preparation.