🔥 Trending Certification · 1Z0-083

Oracle Database
Administration II

Complete your Oracle Certified Professional journey with advanced DBA skills. This second exam of the OCP path covers multitenant architecture, backup & recovery, flashback technologies, performance tuning and SQL optimization for enterprise-grade Oracle Database environments.

Multitenant CDB/PDB RMAN Backup & Recovery Flashback Technologies Performance Tuning SQL Optimization Career Defining

Enroll Now

Multitenant CDB/PDBCreate, manage & secure containers

Backup & RecoveryRMAN strategies & duplication

Flashback TechnologiesPoint-in-time recovery

Performance TuningAWR, ADDM & SQL Tuning Advisor

Exam Questions

120

Minutes Duration

57%

Passing Score

Online

Proctored Exam

Why It's Trending

The Final Step to Becoming an Oracle Certified Professional

Database Administration II completes the OCP DBA credential, validating advanced skills in multitenant architecture, backup/recovery and performance tuning that organizations rely on to keep production systems running.

Trending

90%

Of Oracle Job Postings Require OCP

Completing the OCP DBA path with 1Z0-083 strengthens your candidacy for senior DBA roles.

50K+

Senior DBA Roles Requiring OCP

Backup, recovery and performance tuning expertise are core requirements for senior positions.

Trending

Step 2

Of the Two-Exam OCP Path

Database Administration II (1Z0-083) completes the certification started with 1Z0-082.

+25%

Average Salary Uplift

Fully OCP-certified DBAs command a strong premium over partially certified peers.

Course Content

Complete Database Administration II Curriculum

Click any module to expand and explore the topics covered in detail.

Creating CDBs and Regular PDBs

3 Topics

Configure and create a CDB

Create a new PDB from the CDB seed

Explore the structure of PDBs

Manage CDBs and PDBs

6 Topics

Manage PDB service names and connections

Manage startup, shutdown and availability of CDBs and PDBs

Change different modes and settings of PDBs

Evaluate the impact of parameter value changes

Performance management in CDBs and PDBs

Control CDB and PDB resource usage with Oracle Resource Manager

Backup and Duplicate

3 Topics

Perform Backup and Recover CDBs and PDBs

Duplicate an active PDB

Duplicate a Database

Upgrading and Transporting CDBs and Regular PDBs

2 Topics

Upgrade an Oracle Database

Transport Data

Manage Application PDBs

7 Topics

Explain the purpose of the application root and application seed

Define and create application PDBs

Install, upgrade and Patch applications

Create and administer Application PDBs

Clone PDBs and Application containers

Plug and unplug operations with PDBs and application containers

Comparing Local Undo Mode and Shared Undo Mode

Manage Security in Multitenant databases

4 Topics

Manage Security in Multitenant databases

Manage PDB lockdown profiles

Audit Users in CDBs and PDBs

Manage other types of policies in application containers

Recovery and Flashback

2 Topics

Restore and Recovering Databases with RMAN

Perform CDB and PDB flashback

Backup Strategies and Terminology

9 Topics

Perform Full and Incremental Backups and Recoveries

Compress and Encrypt RMAN Backups

Use a media manager

Create multi-section backups of very large files

Create duplexed backup sets

Create archival backups

Backup of recovery files

Backup non database files

Back up ASM meta data

Restore and Recovery Concepts

2 Topics

Employ the best Oracle Database recovery technology for a given failure situation

Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery

Using Flashback Technologies

2 Topics

Configure the Database to support Flashback

Perform flashback operations

Duplicating a Database

10 Topics

Duplicate Databases

Configure RMAN and Database for Recoverability

Configure and use the RMAN recovery catalog

Detect and repair database and database block corruption

Diagnosing Database Issues

Restore and Recover Databases with RMAN

Perform Non RMAN database recovery

Transport Data

Interpret RMAN message output

Diagnose RMAN performance issues

Install Grid Infrastructure and Oracle Database

7 Topics

Install Grid Infrastructure for a Standalone server

Install Oracle Database software

Patch Grid Infrastructure and Oracle Database

Upgrade Oracle Grid Infrastructure

Image and RPM based Database Installation

Create, Delete and Configure Databases using DBCA

Configure and use Oracle Restart to manage components

Upgrade the Oracle Database

11 Topics

Plan for Upgrading an Oracle Database

Upgrade an Oracle Database

Perform Post-Upgrade tasks

Rapid Home Provisioning

Install Oracle Database software

Create, Delete and Configure Databases using DBCA

Creating CDBs and Regular PDBs

Use Miscellaneous 19c New Features

Use the RMAN recovery catalog

Use Flashback Database

Use new Diagnosability Features

Monitoring and Tuning Database Performance

8 Topics

Managing Memory Components

Understanding AWR

Understanding the Advisory Framework

Monitoring Wait Events, Sessions, and Services

Managing Metric Thresholds and Alerts

Understanding and Using Performance Tuning Methodology

Performing Performance Planning

Understanding ADDM

Tuning SQL Statements

5 Topics

Understanding The Oracle Optimizer

Using SQL Tuning Advisor

Managing Optimizer Statistics

Using SQL Access Advisor

Understanding the SQL Tuning Process

FAQs

Frequently Asked Questions

Who should take the 1Z0-083 exam?

DBAs who have completed Database Administration I (1Z0-082) and want to complete the Oracle Certified Professional DBA credential.

Do I need to pass 1Z0-082 first?

Both exams are required for the OCP DBA certification, though they can be taken in either order. 1Z0-082 covers foundational skills that support 1Z0-083 topics.

Is the 1Z0-083 exam proctored?

Yes. The exam is delivered as a proctored online exam, monitored to validate candidate identity and exam integrity.

What topics carry the most weight in this exam?

Multitenant CDB/PDB administration, RMAN backup and recovery, flashback technologies, and performance/SQL tuning are core focus areas across the 15 exam objectives.

What certifications complement this credential?

RAC, ASM & Grid Infrastructure (1Z0-078) and 19c Data Guard Administrator (1Z0-076) build on OCP DBA skills for high-availability specialization.

How is the exam scored?

The exam consists of 68 multiple choice questions to be completed in 120 minutes, with a passing score of 57%.

Oracle Database
Administration II

The Final Step to Becoming an Oracle Certified Professional

Advance Your Oracle DBA Career

Exam 1Z0-083: Oracle Database Administration II

Complete Database Administration II Curriculum

Frequently Asked Questions

Complete Your Oracle Certified Professional Credential

Oracle DatabaseAdministration II

The Final Step to Becoming an Oracle Certified Professional

Advance Your Oracle DBA Career

Exam 1Z0-083: Oracle Database Administration II

Complete Database Administration II Curriculum

Frequently Asked Questions

Complete Your Oracle Certified Professional Credential

Oracle Database
Administration II