Oracle 12c OCP Upgrade Exam 1Z1-060 – New Features of Oracle Database 12c

This section is geared towards content for a quick preparation of the 1Z1-060 Upgrade to Oracle Database 12c OCP Exam. This is intended to be an aid and can be combined with other training material to help gain the knowledge and the skills to achieve results in the OCP Upgrade Exam.

Please stay tuned. This page will be updated as more training material is tested and compiled in a user friendly format.

Oracle 12c OCP Upgrade Exam 1Z1-060

Enterprise Manager and Other Tools

Manage CDB & PDB with EM Express
Manage CDB & PDB Using OUI
DBCA for installation and configuration

Basics of Multitenant Container Database

Benefits of multitenant databases
Root and multitenant architecture

Configuring and Creating CDBs and PDBs

Create and configure a CDB
Migrate non-CDB database to a PDB

Managing CDBs and PDBs

Connecting to a CDB/PDB
Start up / shut down CDB/PDB databases
Change instance parameters for a CDB/PDB

Managing Tablespaces, Common and Local Users, Privileges and Roles

Managing tablespaces in a CDB/PDB
Managing users and privileges for CDB/PDB

Backup, Recovery and Flashback for a CDB/PDB

Backup of CDB and PDB
• Recovery of CDB and PDB
Flashback for a CDB

Information Lifecycle Management and Storage Enhancements

• ILM features
• Perform tracking and automated data placement
Use Online Move Datafile

In-Database Archiving and Valid-Time Temporal

• Differentiate between IL and Valid-Time Temporal
Set and use Valid Time Temporal
Use In-Database archiving


Enable and configure Unified Audit Data Trail
• Create and enable audit policies


• Use administrative privileges
• Create, enable and use privilege analysis

Oracle Data Redaction

Use and manage Oracle Data Redaction policies
• RMAN and Flashback Data Archive

Use RMAN enhancements

• Implement the new features in Flashback Data Archive
• Real-Time Database Operation Monitoring
• Implement real-time database operation monitoring

SQL Tuning

• Use Adaptive Execution Plans
• Use enhanced features of statistics gathering
• Use Automatic SQL Plan Management

Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics

• Perform emergency monitoring and real-time ADDM
• Generate ADDM Compare Period
• Diagnose performance issues using ASH enhancements

Resource Manager and Other Performance Enhancements

• Use Resource Manager for a CDB and PDB
• Explain Multi-process Multi-threaded Oracle architecture
• Use Flash Cache

Index and Table Enhancements

• Use Index enhancements
• Use Table enhancements

Use Online operation enhancements

• ADR and Network Enhancements
• Explain ADR enhancements
• Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
• Use Oracle Data Pump enhancements

Use SQL*Loader and External table enhancements

• Partitioning Enhancements
• Explain Partitioning enhancements
• Explain Index enhancements for partitioned tables

SQL Enhancements

• Use Oracle Database Migration Assistant for Unicode
• Use Row limiting clause, and secure file LOBs enhancements
• Configure extended datatypes

Leave a Reply

Your email address will not be published.