Oracle credentialCER0445Active

Oracle Database Administration 2019 Certified Professional

Exam code: 1Z0-082Oracle Database up to and including Oracle 19cOracle Database
Official provider page
Oracle
Credential
Certification
Exam duration
120 min

credential overview

About this credential

The Oracle Database Administration 2019 Certified Professional credential demonstrates theoretical understanding and practical skills required to configure and manage Oracle Databases up to and including Oracle 19c. This exam is the first exam in a two-exam path and validates SQL programming, database administration, and network administration skills.

Assessment

Exam details

1Z0-082

Oracle Database Administration 2019 Certified Professional

Required exam
Duration
120 min
Format
Proctored exam
Delivery
Oracle University
Passing score
60%
Proctored
Yes
View exam details
1Z0-083

Oracle Database Administration 2019 Certified Professional

Required exam
Duration
120 min
Format
Proctored exam
Delivery
Oracle University
Passing score
57%
Proctored
Yes
View exam details

Exam blueprint

Skills measured

Skills measured52 topics
  • Understanding Oracle Database Architecture - Oracle Database: Administration Workshop
  • Managing Database Instances - Oracle Database: Administration Workshop
  • Managing Users, Roles and Privileges - Oracle Database: Administration Workshop
  • Managing Storage - Oracle Database: Administration Workshop
  • Moving Data - Oracle Database: Administration Workshop
  • Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop
  • Configuring Oracle Net Services - Oracle Database: Administration Workshop
  • Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop
  • Managing Undo - Oracle Database: Administration Workshop
  • Restricting and Sorting Data - Oracle Database: Introduction to SQL
  • Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to SQL
  • Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL
  • Using SET Operators - Oracle Database: Introduction to SQL
  • Understanding Data Definition Language - Oracle Database: Introduction to SQL
  • Managing Views - Oracle Database: Introduction to SQL
  • Managing Data in Different Time Zones - Oracle Database: Introduction to SQL
  • Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL
  • Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL
  • Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL
  • Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL
  • Managing Tables using DML statements - Oracle Database: Introduction to SQL
  • Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL
  • Managing Schema Objects - Oracle Database: Introduction to SQL
  • Creating CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
  • Manage CDBs and PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
  • Backup and Duplicate - Oracle Database: Managing Multitenant Architecture Ed 1
  • Upgrading and Transporting CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
  • Manage Application PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
  • Manage Security in Multitenant databases - Oracle Database: Managing Multitenant Architecture Ed 1
  • Recovery and Flashback - Oracle Database: Managing Multitenant Architecture Ed 1
  • Backup Strategies and Terminology - Oracle Database: Backup and Recovery Workshop
  • Restore and Recovery Concepts - Oracle Database: Backup and Recovery Workshop
  • Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop
  • Duplicating a Database - Oracle Database: Backup and Recovery Workshop
  • Configuring and Using RMAN - Oracle Database: Backup and Recovery Workshop
  • Diagnosing Failures - Oracle Database: Backup and Recovery Workshop
  • Performing Recovery - Oracle Database: Backup and Recovery Workshop
  • Transporting Data - Oracle Database: Backup and Recovery Workshop
  • RMAN Troubleshooting and Tuning - Oracle Database: Backup and Recovery Workshop
  • Install Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Patching Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Upgrading to Oracle Grid Infrastructure - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Oracle Database 18c: New Features - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Creating an Oracle Database by using DBCA - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Oracle Restart - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Upgrade the Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Install Grid Infrastructure for a Standalone server - Oracle Database: Deploy, Patch and Upgrade Workshop
  • Using General Overall Database Enhancements - Oracle Database 19c: New Features for Administrators
  • Using Availability Enhancements - Oracle Database 19c: New Features for Administrators
  • Using Diagnosibility Enhancements - Oracle Database 19c: New Features for Administrators
  • Monitoring and Tuning Database Performance - Oracle Database: Administration Workshop
  • Tuning SQL Statements - Oracle Database: Administration Workshop

Before you certify

Requirements and recommended experience

Certification requirement

Step 1 - Pass Oracle Database 23ai Administration Associate OR Oracle Database Administration I (1Z0-082).

Certification requirement

Step 2 - Pass Oracle Database Administration II (1Z0-083).

Recommended experience

A combination of Oracle training and hands-on experience attained via labs and/or field experience provides the best preparation for passing the exam.

Certification requirement

Oracle Database 23ai Administration Associate

Certification requirement

Oracle Database 10g Administrator Certified Professional (Retired)

Certification requirement

Oracle Database 11g Administrator Certified Professional (Retired)

Certification requirement

Oracle Database 12c Administrator Certified Professional (Retired)

Certification requirement

Oracle Database 12c R2 Administration Certified Professional (Retired)

Certification requirement

Oracle Database 10g Certified Associate (Retired)

Certification requirement

Oracle Database 11g Certified Associate (Retired)

Certification requirement

Oracle Database 12c Certified Associate (Retired)

Certification requirement

Oracle Database 12c R2 Certified Associate (Retired)

Certification requirement

Pass Oracle Database Administration II (1Z0-083).

Certification requirement

Pass Oracle Database Administration II (Available only in China) 1Z0-083-CHN.

Preparation

Official learning resources

Training course

Earn the Oracle Database Administration 2019 Certified Professional Credential

Learning path

Technology Learning Subscription

Credential lifecycle

Status, validity and renewal

Credential lifecycle

Corporate certification enablement

Turn this pathway into a team capability plan

We can align the learning path, instructor support, practice environment and delivery schedule to your team’s roles and certification target.