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
80
65%
Professional
Registration
$245 USD
Pearson VUE or online proctoring
English
Validity
Must be recertified for current database versions
Pass Oracle Database 19c Administration II (1Z0-083); Pass Oracle Database Administration I (1Z0-082) and Oracle Database Administration II (1Z0-083) for full 19c certification
1Z0-060 Exam Topics and Domains
1Z0-060 is organized into 10 weighted domains. Expect to work with Oracle Multitenant, SQL*Plus, DBCA, Oracle ILM, and more.
1
Oracle Enterprise Manager and Other Tools
8%
Oracle Enterprise Manager Database Express
Using EM Database Express for database monitoring
- Use Oracle Enterprise Manager Database Express to monitor database performance
- Configure and access EM Database Express
Additional Database Monitoring Tools
SQL Developer and other management tools
Utilize various Oracle Database management and monitoring tools
2
Basics of Multitenant Container Database (CDB)
12%
Multitenant Architecture
Understanding CDB and PDB architecture
- Explain the multitenant architecture
- Identify components of CDB and PDB
- Describe benefits of Oracle Multitenant
CDB and PDB Concepts
Root and seed containers
- Understand the role of root and seed containers
- Describe container isolation mechanisms
3
Configuring and Creating CDBs and PDBs
15%
Creating Container Databases
CDB creation methods
- Create a CDB using DBCA
- Create a CDB manually using SQL statements
Creating Pluggable Databases
PDB creation methodsPDB cloning techniques
- Create PDBs using various methods
- Clone PDBs locally and remotely
- Understand PDB creation options
4
Managing CDBs and PDBs
18%
Starting and Stopping CDBs and PDBs
CDB and PDB lifecycle management
- Start and stop CDBs
- Open and close PDBs
- Manage PDB state across restarts
Connecting to CDBs and PDBs
Connection methods
- Establish connections to root and PDBs
- Switch between containers in a session
Plugging and Unplugging PDBs
PDB portability operations
- Unplug PDBs from a CDB
- Plug PDBs into a CDB
- Validate PDB compatibility
5
Managing Tablespaces, Users, Privileges and Roles
10%
Common and Local Users
User types in multitenant architecture
- Create common and local users
- Understand user scope in CDB/PDB architecture
Common and Local Roles
Role management in multitenant
- Create and manage common and local roles
- Grant privileges using CONTAINER clause
Tablespace Management in CDB/PDB
Tablespace operations in multitenant
- Manage tablespaces in CDB and PDB contexts
- Configure Oracle Managed Files for PDBs
6
Backup, Recovery and Flashback for CDB/PDB
12%
RMAN Enhancements for CDB/PDB
Backup strategies in multitenant
- Perform backups of CDB and individual PDBs
- Understand RMAN multitenant features
Recovery Operations
CDB and PDB recovery
- Recover CDB and PDBs using RMAN
- Perform point-in-time recovery for PDBs
- Use Flashback features with multitenant
7
SQL Enhancements
8%
New SQL Features in 12c
SQL syntax improvementsJSON support
- Use new SQL syntax features in 12c
- Work with JSON data in Oracle Database
8
Information Lifecycle Management and Storage Enhancements
10%
Automatic Data Optimization (ADO)
ILM policies and ADO
- Configure Automatic Data Optimization
- Implement ILM policies using ADO
In-Database Archiving
Row archival and temporal validity
- Implement in-database archiving
- Use temporal validity features
9
Auditing Enhancements
10%
Unified Auditing
Unified audit trail
- Configure unified auditing
- Create and manage unified audit policies
- Query unified audit trail
Data Redaction
Oracle Data Redaction
- Implement Oracle Data Redaction
- Create redaction policies for sensitive data
10
Performance and Optimizer Enhancements
7%
Adaptive Query Optimization
Adaptive execution plans
- Understand adaptive query optimization features
- Use automatic SQL plan management
In-Memory Column Store
In-Memory architecture and features
- Configure Database In-Memory
- Populate tables in In-Memory Column Store
How do I earn this certification?
Passing 1Z0-060 earns the Oracle Database 12c Administrator Certified Professional certification. It sits in the Oracle Database Administration track.
Current Level Exams
- 1Z0-061 - Oracle Database 12c: SQL Fundamentals
- 1Z0-062 - Oracle Database 12c: Installation and Administration
- 1Z0-063 - Oracle Database 12c: Advanced Administration
Next Level Options
OCM - Oracle Certified Master Database Administrator Highest level Oracle Database certification with hands-on lab exam
Alternative Paths
- 1Z0-071 - Oracle Database SQLSQL-focused certification path
- 1Z0-076 - Oracle Database 19c: Data Guard AdministrationSpecialized in High Availability with Data Guard
- 1Z0-078 - Oracle Database 19c: RAC, ASM, and Grid Infrastructure AdministrationSpecialized in Oracle RAC and Grid Infrastructure
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-060 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- RETIRED
- Last content update: 2020-08-31
- Announcement date: 2020-06-15
Updates
- Oracle Multitenant Evolution from 12c to 19c and beyond Core feature in both retired 1Z0-060 and current 1Z0-082/1Z0-083 exams • Release date: 2013-2024
- Oracle Database In-Memory 12c introduction, 19c enhancements Featured in 1Z0-060, continues in 19c certifications with enhanced features • Release date: 2014-2024
- Unified Auditing 12c introduction, 19c default Major topic in 1Z0-060, remains critical in current certifications • Release date: 2013-2024
Who should take this exam?
Oracle Certified Professional on Oracle Database 11g or earlier versions (7, 8, 8i, 9i, 10g)
- Hands-on experience with Oracle Database 11g
- Familiarity with database administration concepts