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