Oracle Database Administrator Certified Professional

The Oracle Database Administrator Certified Professional (1Z0-083) validates advanced database administration skills for Oracle Database 19c, the industry's leading enterprise database platform. This certification demonstrates expertise in multitenant architecture, backup and recovery, performance tuning, and security—critical skills for managing production Oracle databases at scale.

Request Training Email Inquiry

What is the Oracle Database Administrator Certified Professional (1Z0-083)?

Who Should Take This Course?

Database Administrators managing Oracle 19c databases
System Administrators responsible for database operations
Database Engineers implementing backup and recovery strategies
IT professionals upgrading from earlier Oracle versions
DevOps engineers managing database infrastructure
Solutions Architects designing database solutions
Anyone seeking professional-level Oracle DBA credentials

What You Will Learn in the 1Z0-083 Course

A comprehensive curriculum covering all exam objectives with hands-on labs and real-world practice.

Multitenant Architecture

Master Container Database (CDB) and Pluggable Database (PDB) management.

Creating and configuring CDBs and PDBs
Managing PDB lifecycle: startup, shutdown, cloning
Application containers and application PDBs
PDB resource management and performance tuning
Security and lockdown profiles for PDBs

Backup and Recovery with RMAN

Implement comprehensive backup and recovery strategies using RMAN.

RMAN backup strategies and best practices
Full, incremental, and differential backups
Backup compression and encryption
Recovery scenarios: crash, complete, point-in-time
Flashback database and table recovery
RMAN catalog management and reporting

Performance Tuning and Monitoring

Optimize database performance and troubleshoot issues.

Automatic Workload Repository (AWR) analysis
SQL Tuning Advisor and SQL Access Advisor
Memory management: SGA and PGA tuning
Performance views and wait event analysis
ADDM (Automatic Database Diagnostic Monitor) reports

Patching, Upgrading, and Grid Infrastructure

Deploy, patch, and upgrade Oracle Database environments.

Oracle Grid Infrastructure for standalone servers
Database patching strategies and rolling patches
Upgrading databases to 19c
Oracle Restart configuration
Image and RPM-based installations

Security, Auditing, and Resource Management

Implement security controls and resource management.

Unified auditing in CDBs and PDBs
Data encryption and Transparent Data Encryption (TDE)
Resource Manager for workload management
Privilege analysis and separation of duties
Security best practices for production databases

Course Prerequisites

Pre-requisites training is free when you purchase the course from ProSupport

Oracle Database SQL Certified Associate (1Z0-071) or equivalent SQL knowledge
6-12 months of hands-on Oracle Database administration experience
Understanding of Linux/Unix operating systems
Familiarity with database concepts and architecture

Exam Information

Everything you need to know about the 1Z0-083 certification exam.

Exam Component	Details
Exam Name	Oracle Database Administration II
Exam Code	1Z0-083
Exam Type	Multiple Choice and Multiple Select
Total Questions	85
Passing Score	57%
Exam Duration	150 minutes
Language	English, Japanese, Korean, Simplified Chinese
Exam Provider	Oracle / Pearson VUE
Exam Focus	Advanced administration of Oracle Database 19c including multitenant architecture, RMAN, performance tuning, and patching
Exam Registration	Register at education.oracle.com via Pearson VUE
Retake Policy	14-day waiting period between attempts
Certification Validity	18 months (renewable via recertification or upgrade exams)