Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Oracle
Exam Format
120 min
68
57%
Professional
Registration
$245 USD
Pearson VUE or online proctoring
English
Validity
Lifetime (does not expire)
Oracle certification credentials do not expire; Recommended to stay current with new versions; Can upgrade to newer database versions through upgrade exams
1Z0-083 Exam Topics and Domains
1Z0-083 is organized into 4 weighted domains. Expect to work with Active Database Duplication, DBMS_STATS, Enterprise Manager, Flashback Database, and more.
1
Managing Multitenant Architecture
35%
Creating CDBs and Regular PDBs
Configure and create a CDBCreate a new PDB from the CDB seedExplore the structure of PDBs
- Configure and create container databases
- Create pluggable databases from seed template
- Understand PDB architecture and structure
Manage CDBs and PDBs
Manage PDB service names and connectionsManage startup, shutdown and availability of CDBs and PDBsChange the different modes and settings of PDBsEvaluate the impact of parameter value changesPerformance management in CDBs and PDBsControl CDB and PDB resource usage with Oracle Resource Manager
- Manage PDB lifecycle operations
- Configure and control resource allocation
- Monitor and tune multitenant performance
Manage Application PDBs
Explain the purpose of application root and application seedDefine and create application PDBsInstall, upgrade and Patch applicationsCreate and administer Application PDBsClone PDBs and Application containersPlug and unplug operations with PDBs and application containersComparing Local Undo Mode and Shared Undo Mode
- Understand application container architecture
- Manage application PDB lifecycle
- Implement application versioning and patching
Backup and Duplicate
Perform Backup and Recover CDBs and PDBsDuplicate an active PDBDuplicate a Database
- Implement backup strategies for multitenant
- Perform PDB and CDB recovery
- Execute database duplication
Recovery and Flashback
Restore and Recovering Databases with RMANPerform CDB and PDB flashback
- Perform database recovery with RMAN
- Implement flashback operations
- Configure flashback database
Upgrading and Transporting CDBs and Regular PDBs
Upgrade an Oracle DatabaseTransport Data
- Plan and execute database upgrades
- Transport data between databases
- Manage upgrade procedures
Manage Security in Multitenant databases
Manage Security in Multitenant databasesManage PDB lockdown profilesAudit Users in CDBs and PDBsManage other types of policies in application containers
- Implement security in multitenant environments
- Configure lockdown profiles
- Manage auditing policies
2
Backup and Recovery
30%
Backup Strategies and Terminology
Perform Full and Incremental Backups and RecoveriesCompress and Encrypt RMAN BackupsUse a media managerCreate multi-section backupsCreate duplexed backup setsCreate archival backupsBackup of recovery files and non-database filesBack up ASM metadata
- Implement comprehensive backup strategies
- Configure backup optimization
- Manage backup encryption and compression
Configuring and Using RMAN
Configure RMAN and the Database for RecoverabilityConfigure and Use an RMAN recovery catalog
- Configure RMAN for optimal backup and recovery
- Implement recovery catalog
- Manage RMAN configuration
Restore and Recovery Concepts
Employ the best Oracle Database recovery technologyRecovery technologies for different failure situations
- Understand recovery methodologies
- Select appropriate recovery strategies
- Implement recovery procedures
Performing Recovery
Restore and Recover Databases with RMANPerform Non-RMAN database recovery
- Perform complete and incomplete recovery
- Execute manual recovery procedures
- Verify recovery success
Using Flashback Technologies
Configure database to support FlashbackPerform flashback operations
- Configure flashback technologies
- Perform flashback operations
- Manage flashback retention
Diagnosing Failures
Detect and repair database corruptionDiagnose Database Issues
- Detect database corruption
- Use Data Recovery Advisor
- Implement repair procedures
Transporting Data and Duplicating Databases
Transport DataDuplicate Databases
- Transport data between databases
- Duplicate databases with RMAN
- Configure auxiliary instances
RMAN Troubleshooting and Tuning
Interpret RMAN message outputDiagnose RMAN performance issues
- Troubleshoot RMAN operations
- Tune RMAN performance
- Interpret RMAN output
3
Database Deployment, Patching, and Upgrading
20%
Install Grid Infrastructure and Oracle Database
Install Grid Infrastructure for a Standalone serverInstall Oracle Database software
- Install Grid Infrastructure
- Install Oracle Database software
- Verify installations
Creating an Oracle Database by using DBCA
Create, Delete and Configure Databases using DBCA
- Create databases with DBCA
- Configure database options
- Manage database templates
Patching Grid Infrastructure and Oracle Database
Patch Grid Infrastructure and Oracle Database
- Apply patches to Grid Infrastructure
- Patch Oracle Database
- Manage patch conflicts
Upgrading Oracle Grid Infrastructure and Database
Upgrade Oracle Grid InfrastructurePlan for Upgrading an Oracle DatabaseUpgrade an Oracle DatabasePerform Post-Upgrade tasks
- Plan database upgrades
- Execute upgrade procedures
- Perform post-upgrade tasks
Oracle Restart
Configure and use Oracle Restart to manage components
- Configure Oracle Restart
- Manage database components
- Implement high availability
Oracle Database 19c New Features
Image and RPM-based Database InstallationRapid Home ProvisioningUse Miscellaneous 19c New Features
- Understand 19c installation enhancements
- Implement Rapid Home Provisioning
- Use new 19c features
4
Monitoring and Tuning Database Performance
15%
Monitoring and Tuning Database Performance
Managing Memory ComponentsUnderstanding The Automatic Workload Repository (AWR)Understanding The Advisory FrameworkMonitoring Wait Events, Sessions, and ServicesManaging Metric Thresholds and AlertsPerformance Tuning MethodologyPerforming Performance PlanningUnderstanding The Automatic Database Diagnostic Monitor (ADDM)
- Monitor database performance
- Use AWR and ADDM
- Implement performance tuning
Tuning SQL Statements
Understanding The Oracle OptimizerUsing The SQL Tuning AdvisorManaging Optimizer StatisticsUsing The SQL Access AdvisorUnderstanding The SQL Tuning Process
- Understand optimizer operation
- Use SQL tuning advisors
- Manage optimizer statistics
How do I earn this certification?
Passing 1Z0-083 earns the Oracle Database Administration 2019 Certified Professional certification. It sits in the Oracle Database Administration track.
Current Level Exams
1Z0-082 - Oracle Database Administration IFoundation DBA skills: database architecture, instance management, users, roles, privileges, storage
Next Level Options
- 1Z0-084 - Oracle Database 19c: Performance and TuningDeepens performance tuning expertise
- 1Z0-144 - Oracle Database 11g: Program with PL/SQL Expands into database programming
- Oracle Database 19c RAC - Real Application Clusters Administration Cluster database administration skills
Alternative Paths
1Z0-819 - Java SE 11 DeveloperComplementary development skills for database applications
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for 1Z0-083 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2024-11-01
Updates
- Oracle Multitenant Architecture 19c
- RMAN Backup and Recovery 19c
- Database Patching and Upgrading 19c
- Performance Tuning 19c
Who should take this exam?
This exam is typically taken by Oracle Database Administrators and Database professionals managing Oracle Database 19c.
Exam Code: 1Z0-082; Exam Name: Oracle Database Administration I; Note: Must pass 1Z0-082 to earn OCP certification (can be taken in any order)
- Experience with Oracle Database
- Knowledge of database administration concepts and techniques
- Experience with SQL Fundamentals
- Writing PL/SQL programs
- Hands-on experience as an Oracle Database Administrator including creating tablespaces, redo logs, users and roles
- Administering privileges
- Configuring and using RMAN for backup and recovery scenarios
- Configuring and using Multi-Tenant
- Deploying, Patching and maintaining Oracle Database installations
What jobs can I get with this?
Database Administrator
Senior Database Administrator
Oracle DBA
Database Consultant
Database Architect