Yet Another OCM

Home
Announcements
Book Reviews
OCM Questions and Answers

Home >

12C OCP Upgrade

These are my notes as I study for the 12C OCP Upgrade Exam .

These topics are correct as of 2020-01-25. See Exam 1Z0-060 Topics

Exam Topics

Section 1: New Features of Oracle Database 12c

ADR and Network Enhancements

Explain ADR Enhancements
Network Enhancements

Auditing

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

Backup, Recovery and Flashback for a CDB/PDB

Perform backup of CDB and PDB
Perform recovery of CDB and PDB

Basics of Multitenant Container Database (CDB)

Explain root and multitenant architecture
Identify the benefits of the multitenant container database

Configuring and Creating CDBs and PDBs

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

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

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

Enterprise Manager and Other Tools

Use EM Express
Use OUI, DBCA for installation and configuration

In-Database Archiving and Valid-Time Temporal

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

Index and Table Enhancements

Use Index enhancements
Use Online operation enhancements
Use Table enhancements

Information Lifecycle Management and Storage Enhancements

Move a data file online
Perform tracking and automated data placement
Use ILM features

Managing CDBs and PDBs

Change instance parameters for a CDB/PDB
Establish connection to a CDB/PDB
Start up and shut down a CDB/PDB

Managing Tablespaces, Common and Local Users, Privileges and Roles

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

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements

Use Oracle Data Pump enhancements
Use SQL*Loader and External table enhancements

Oracle Data Redaction
Partitioning Enhancements

Explain Index enhancements for partitioned tables
Explain Partitioning enhancements

Privileges

Create, enable and use privilege analysis
Use administrative privileges

Real-Time Database Operation Monitoring
Resource Manager and Other Performance Enhancements

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

RMAN and Flashback Data Archive

Implement the new features in Flashback Data Archive
Use RMAN enhancements

SQL Enhancements

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

SQL Tuning

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

Section 2: Key DBA Skills

Core Administration

Apply and review patches
Back up and recover the database
Configure server and client network for a database
Detect and repair data failures with Data Recovery Advisor
Explain the fundamentals of DB architecture
Implement Flashback Technology
Install and configure a database
Load and Unload Data
Monitor database alerts
Perform daily administration tasks
Troubleshoot network and database issues

Miscellaneous

Create a default permanent tablespace
Relocate SYSAUX occupants
Use Direct NFS
Use Secure File LOBs
Use the Redo Logfile Size Advisor

Performance Management

Analyze and identify performance issues
Design the database layout for optimal performance
Implement Application Tuning
Manage memory
Monitor performance
Perform real application testing
Use Resource Manager to manage resources

Security

Configure and manage auditing
Create the password file
Develop and implement a security policy
Implement column and tablespace encryption

Storage

Administer ASM
Implement Space Management
Manage ASM disks and diskgroups
Manage ASM instance
Manage database structures
Manage VLDB

This work © 2024 by Douglas Hawthorne is licensed under CC BY-NC-SA 4.0