1Z0-082 + 1Z0-083 · ● Active · Professional · Oracle
Exam facts
| Field | Value |
|---|---|
| Cost | $245 USD per exam (regional pricing may vary) |
| Duration | 120 minutes per exam |
| Questions | 1Z0-082: 90 questions; 1Z0-083: 68 questions |
| Passing Score | 1Z0-082: 60%; 1Z0-083: 57% scaled |
| Format | Multiple choice and scenario-based |
| Delivery | Pearson VUE, OnVUE (online proctored) |
| Languages | English |
| Valid | 3 years from pass date |
| Renewal | Recertification: pass 1Z0-084 (Expert level) or retake both exams |
| Prerequisites | None formal; foundational database knowledge recommended |
| Released | 1Z0-082: 2019; 1Z0-083: 2019 |
| Retiring | N/A — both exams remain current as of 2026 |
Vendor source — Oracle Education ↗ 1Z0-082 exam page — Oracle Database Administration I ↗ 1Z0-083 exam page — Oracle Database Administration II ↗ Official study guide — Oracle Database 19c Study Guide ↗
About
The Oracle Database 19c Administrator Professional certification is a two-part exam (1Z0-082 and 1Z0-083) that validates enterprise-grade database administration skills on Oracle Database 19c. Exam 1Z0-082 (Administration I) tests foundational skills: database architecture, instance startup/shutdown, user/privilege management, tablespace and datafile administration, and basic backup/recovery. Exam 1Z0-083 (Administration II) covers advanced topics: multitenant container databases (CDB), pluggable databases (PDB), RMAN backup strategies, Flashback technologies, Data Guard, performance tuning, and patching/upgrades. Both exams became the Professional-level certification in 2019 and remain the primary Oracle DBA credential through 2026.
Domain context — Data/Database
Relational and non-relational database administration, backup/recovery, security, and performance tuning across commercial, open-source, and vendor-specific platforms (Oracle, SQL Server, PostgreSQL, MongoDB, etc.). Oracle Database 19c focuses on enterprise-grade relational administration at the Professional level.
Topics covered (1Z0-082: Administration I)
- Database architecture and Oracle instance components (15–20%)
- Creating and managing databases (10–15%)
- Managing database users and security (roles, privileges, profiles) (10–15%)
- Managing tablespaces and datafiles (10–15%)
- Undo management and transactions (5–10%)
- Database backup and recovery (RMAN basics) (15–20%)
- Oracle network configuration (SQL*Net, listener) (5–10%)
- Database monitoring and performance (5–10%)
Source: Oracle 1Z0-082 Study Guide ↗
Topics covered (1Z0-083: Administration II)
- Multitenant container database (CDB) architecture and administration
- Pluggable database (PDB) creation, configuration, and cloning
- Advanced backup and recovery (RMAN): incremental backups, compression, active duplication, TSPITR
- Flashback Database, Flashback PDB, and point-in-time recovery
- Oracle Data Guard: physical standby, logical standby, protection modes
- Real Application Clusters (RAC) and Oracle Automatic Storage Management (ASM) fundamentals
- Performance tuning: AWR, ADDM, SQL Tuning Advisor, wait events, SGA/PGA advisors
- Patching and database upgrades (Release Updates, patches)
- Database security: encryption, auditing, virtual private database (VPD)
- Resource Manager and metric thresholds in multitenant environments
Source: Oracle 1Z0-083 Study Guide ↗
Common skills at Data/Database · Professional
Shared content for the Data/Database domain at Professional level — not specific to this cert.
- Enterprise backup and recovery strategy (RTO/RPO design)
- High-availability and disaster-recovery architecture (replication, failover, switchover)
- Query optimization and execution-plan analysis
- Capacity planning and storage performance tuning
- Database security: encryption, access control, audit logging, compliance
- Scripting for automation (SQL, PL/SQL, Python, Bash)
- Cross-platform data migration and ETL pipeline design
- Monitoring, alerting, and incident response
- Vendor-specific tuning tools and diagnostics
Recommended courses at Data/Database · Professional
| Provider | Title | Cost | URL |
|---|---|---|---|
| Oracle University (Official) | Oracle Database 19c: Administration I + II | ~$2,500 (class) | ↗ |
| Udemy (Combined course) | 1Z0-082 | 1Z0-083 | Oracle DB 19c Administration I & II | $15–$80 | ↗ |
| Udemy (Instructor: comprehensive) | Oracle 1Z0-082 Exam Prep & Oracle DBA Administration | $15–$80 | ↗ |
| Udemy (1Z0-083 focused) | 1Z0-083: Oracle Database Administration II Practice Test | $15–$80 | ↗ |
| Pluralsight | Oracle Database 19c Administration Path | $299/year (subscription) | ↗ |
| YouTube (Free) | Oracle Database Administration fundamentals playlists | Free | ↗ |
Practice exams
| Provider | Title | Cost | URL |
|---|---|---|---|
| DBExam | 1Z0-082 & 1Z0-083 Complete Study Manual + Practice | $50–$100 | ↗ |
| SkillCertPro | 1Z0-082 & 1Z0-083 Exam Questions (updated 2026) | $20–$40 | ↗ |
| Udemy (Practice tests) | 1Z0-082 Oracle Database Admin I Practice Exams (Unofficial) | $15–$30 | ↗ |
| Udemy (1Z0-083 Practice) | 1Z0-083 Oracle Database Administration II Practice Tests | $15–$30 | ↗ |
| Oracle Official (limited) | Oracle Database 19c Sample Questions | Free (limited set) | ↗ |
Books
| Title | Author | Publisher | Year | ISBN | URL |
|---|---|---|---|---|---|
| 1Z0-082: Oracle Database Administration I Certification Exam Guide | Anand Vemula | McGraw-Hill | 2023 | 9798310072602 | ↗ |
| Oracle Database 19c: Basic SQL | Bob Bryla, Biju Thomas | Oracle Press | 2019 | 9781492072652 | ↗ |
| Oracle Database 12c The Complete Reference | Bob Bryla, Kevin Loney | Oracle Press | 2014 | 9780071801751 | ↗ |
| Oracle Database 12c DBA Handbook | Bob Bryla | Oracle Press | 2014 | 9780071798781 | ↗ |
| Oracle Database Administration: The Essential Reference | Norbert Debes | O'Reilly | 1998 | 1565925165 | ↗ |
Book note: The Vemula guide (9798310072602) is the most current study guide specifically for 1Z0-082. Bob Bryla's works remain reference-quality but are focused on 12c/19c fundamentals rather than the 2019 exam blueprint. For 1Z0-083, most candidates supplement Udemy courses + practice exams, as no recent Sybex/McGraw-Hill guide dedicated to 1Z0-083 was found as of May 2026.
Typical job titles at Data/Database · Professional
Oracle Database Administrator · Senior DBA · Database Administrator (Oracle focus) · Principal Database Administrator · Database Performance Analyst · DBA Engineer · Database Infrastructure Engineer · Database Architect (junior level)
(Job titles drawn from current Oracle database job boards and LinkedIn postings requiring OCP 19c DBA certification.)
Salary
| Region | Range | Source |
|---|---|---|
| USD | $133,000 – $177,000 (DBA); $185,000 – $234,000 (Senior DBA) | Glassdoor ↗ · Glassdoor Senior ↗ · PayScale ↗ |
| ZAR | R140,000 – R1,000,000 (DBA); R199,000 – R1,000,000 (Senior DBA) | PayScale ZA ↗ · CareerJunction ↗ |
| GBP | £36,000 – £60,000 (junior to experienced) | PayScale UK ↗ |
Salary note: Oracle DBA roles command premium compensation in all regions due to the specialized nature of Oracle Database 19c administration and the high cost of downtime in enterprise environments. Experience + RAC/Data Guard/multitenant expertise significantly increases earning potential.
Skills validated
Cert-specific — what this exam actually tests, distinct from the shared "Common skills" above.
- Oracle Database instance architecture (SGA, PGA, background processes)
- RMAN (Recovery Manager): full, incremental, compressed backups; active duplication; TSPITR
- Multitenant Container Database (CDB) and Pluggable Database (PDB) administration
- Oracle Data Guard: physical standby, logical standby, protection modes, switchover/failover
- Flashback Database and point-in-time recovery
- Oracle Real Application Clusters (RAC) and Oracle Automatic Storage Management (ASM) concepts
- Performance tuning: AWR, ADDM, SQL Tuning Advisor, wait events, memory advisors
- Database patching and upgrades (Release Updates, one-off patches)
- User and privilege management (RBAC, roles, system/object privileges, profiles)
- Tablespace and datafile management, undo management
- Oracle Net (SQL*Net) listener and connection configuration
- SQL and PL/SQL scripting for automation
- Encryption, auditing, virtual private database (VPD)
- Resource Manager for multitenant environments
Related certifications
- Stacks with: Oracle Database 19c Performance Tuning (1Z0-084) ↗ — advances to Expert level; covers AWR, ADDM, SQL tuning in depth
- Prerequisite for: Oracle Database Expert (1Z0-084); some organizations use 1Z0-082/1Z0-083 as foundation for Exadata certification (1Z0-060)
- Equivalents at this level: Microsoft Certified: SQL Server Database Administrator (DP-300) · Certified Associate: PostgreSQL Associate (PGCA, The Linux Foundation)
- Vendor overview: Oracle Vendor Overview ↗
Sources
- Oracle Education — 1Z0-082 exam page ↗
- Oracle Education — 1Z0-083 exam page ↗
- Oracle Database 19c Study Guide ↗
- Oracle FAQ: Database 2019 Certification ↗
- Glassdoor: Oracle DBA Salary US ↗
- Glassdoor: Senior Oracle DBA Salary US ↗
- PayScale: Oracle DBA South Africa ↗
- CareerJunction: Oracle DBA Jobs ZA ↗
- DBExam: 1Z0-082 & 1Z0-083 Study Guide ↗
- Udemy: Combined 1Z0-082/1Z0-083 Course ↗
Last verified: 2026-05-01 Parent ecosystem: Oracle Database ↗ Parent domain: Data/Database ↗ Vendor overview: Oracle Corporation ↗