Oracle Database Administration II

Exam format

Oracle logo

Oracle Database Administration II Exam Format

1Z0-083

Everything the official exam blueprint specifies: question count, time limit, scoring and the weight each domain carries. The Oracle Database Administration II (1Z0-083) certification is designed for professionals who have mastered foundational administration and are moving toward expert-level management. This exam validates the ability to manage complex Multitenant environments, implement robust backup and recovery solutions using RMAN and Flashback, and optimize database performance through deep-dive monitoring. It also ensures the administrator can maintain high security standards and execute seamless upgrades and patches in a production-grade ecosystem. This is a critical credential for those managing large-scale, mission-critical Oracle ecosystems.

68 questions
120 min
57% to pass
8 domains

Exam facts at a glance

What we know about this exam, and where the information comes from.

SpecificationValue
Questions68
Time limit120 minutes (106s per question)
Passing score57%
Domains8
LevelProfessional
Question bank here68 questions
SourceCertilum's own record — the vendor does not publish this figure

Official domain weights

The percentage of the exam each domain carries. Weight your revision by these numbers, not by what you find hardest.

DomainWeightTopicsPractice Qs
Application PDBs10%
  • Application root and application seed
  • Application PDB creation and administration
  • Cloning, plug/unplug operations
  • +1 more
7
Backup and Recovery20%
  • RMAN configuration and backup strategies
  • Full and incremental backups
  • Compress and encrypt RMAN backups
  • +2 more
14
Database Duplication6%
  • Duplicate an active PDB
  • Duplicate a database
  • Database cloning
4
Multitenant Security8%
  • Security in multitenant databases
  • PDB lockdown profiles
  • Auditing in CDBs and PDBs
6
Patching and Upgrades12%
  • Installing Grid Infrastructure and Oracle Database
  • Patching Grid Infrastructure and Oracle Database
  • Upgrading Oracle Database
  • +1 more
8
Flashback Technologies8%
  • Configuring flashback support
  • Flashback operations
  • CDB and PDB flashback
5
Performance and Tuning18%
  • Monitoring and tuning database performance
  • AWR and ADDM
  • SQL Tuning Advisor and SQL Access Advisor
  • +2 more
12
Multitenant Architecture18%
  • Creating CDBs and Regular PDBs
  • PDB structure and seed
  • Managing CDB and PDB lifecycle
  • +2 more
12

The heaviest domain is Application PDBs at 10%, and that is where lost points cost you the most. Certilum scores you per domain so you can see the difference between a knowledge gap and a formatting problem.

Note from the vendor record: Technology exam (Oracle Database) sold as a single attempt valid for 6 months: USD 245. Base Exam Price $245 / Delta $125 (Oracle Certification Program Guidelines). The price may be displayed in local currency; check pearsonvue.com/oracle by region. Official exam page

More about the Oracle Database Administration II exam

Explore the rest of this page series: format, cost, difficulty, requirements and how to prepare.

Exam costPass rateWho can take itStudy plan

Related certifications

Explore other certifications in the same category and see how they stack up.

CCA Spark and Hadoop Developer
CCA Spark and Hadoop Developer
ClouderaCloudera
CDP Administrator - Private Cloud Base
CDP Administrator - Private Cloud Base
ClouderaCloudera
CDP Administrator - Public Cloud
CDP Administrator - Public Cloud
ClouderaCloudera
Confluent Certified Administrator for Apache Kafka
Confluent Certified Administrator for Apache Kafka
ConfluentConfluent
Oracle Database Administration I
Oracle Database Administration I
OracleOracle
Oracle MySQL 8.0 Database Administrator
Oracle MySQL 8.0 Database Administrator
OracleOracle

Frequently asked questions

Everything you need to know about the Oracle Database Administration II exam.