You are previewing OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060), 2nd Edition.
O'Reilly logo
OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060), 2nd Edition

Book Description

A Fully Integrated Study System for OCP Exam 1Z0-060

Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of the new features of Oracle Database 12c, including:

  • Oracle Enterprise Manager Database Express and additional tools for database monitoring
  • Multitenant container databases and pluggable databases
  • Auditing, administrative privileges, data redaction, and other Oracle security features
  • Adaptive execution plans, adaptive statistics, and automatic SQL plan management
  • Oracle Recovery Manager backup and recovery improvements
  • Oracle Database Resource Manager and other performance enhancements
  • Oracle Data Pump, SQL*Loader, external tables, and online operations enhancements
  • Improvements to information lifecycle management and storage, including automatic data optimization, in-database archiving, and temporal validity

Electronic content includes:

  • 170 practice exam questions with detailed answer explanations
  • PDF copy of the book

Table of Contents

  1. Cover 
  2. Title Page
  3. Copyright Page
  4. About the Author
    1. About the Technical Editor
  5. Contents 
  6. Acknowledgments
  7. Preface
  8. Introduction
    1. Changes to the Exam Composition
    2. Exam Structure
    3. How to Prepare for the Exam
  9. 1: Enterprise Manager and Database Monitoring
    1. Use Oracle Enterprise Manager Express, OUI, and DBCA (Exam Objective 1.01)
      1. EM Database Express
      2. Database Configuration Assistant: New Features
      3. Oracle SQL*Developer Enhancements
    2. Implement Real-Time Database Operation Monitoring (Exam Objective 1.02)
      1. Definition of a Database Operation
      2. How Real-Time Database Monitoring Helps You
      3. Identifying a Database Operation
      4. Enabling Database Operation Monitoring
      5. A Database Operation Monitoring Example
      6. Monitoring Load Database Operations
      7. Monitoring the Progress of a Database Operation
    3. Perform Emergency Monitoring and Real-Time ADDM (Exam Objective 1.03)
      1. Emergency Monitoring
      2. Real-Time ADDM
      3. Real-Time Connection Modes
      4. Real-Time ADDM Triggers
      5. Producing a Real-Time ADDM Report
      6. Combining Emergency Monitoring and Real-Time ADDM
    4. Generate a Compare Period ADDM Report (Exam Objective 1.04)
      1. How Compare Periods ADDM Helps
      2. Generating a Compare Period ADDM Report
    5. Understand ASH, ADR, and Network Enhancements (Exam Objective 1.05)
      1. Diagnosing Performance Issues Using Active Session History (ASH) Analytics
      2. ADR Enhancements
      3. The DDL Log
      4. The Debug Log
      5. Network-Related Enhancements
    6. Two-Minute Drill
    7. Self Test
    8. Self Test Answers
  10. 2: Multitenant Databases—Architecture and Configuration
    1. Identify the Benefits of the Multitenant Container Database (Exam Objective 2.01)
      1. Configuration Options in Oracle Database 12c
    2. Explain Root and Multitenant Architecture (Exam Objective 2.02)
      1. Managing a CDB
      2. Organization of the Instance and Storage
      3. Types of Containers
      4. Local and Common Users
      5. Local and Common Roles and Privileges
      6. Shared and Non-Shared Objects
    3. Create and Configure CDBs and PDBs (Exam Objective 2.03)
      1. Creating a CDB
      2. Configuring EM Express in a CDB
      3. Creating and Configuring a PDB
      4. Dropping a Pluggable Database
    4. Migrate a Non-CDB to a PDB Database (Exam Objective 2.04)
      1. Migrating the Non-CDB Using the DBMS_PDB Package
      2. Plugging a Non-CDB into a CDB Using Data Pump
      3. Using Golden Gate Replication to Plug a Non-CDB into a PDB
    5. Two-Minute Drill
    6. Self Test
    7. Self Test Answers
  11. 3: Managing CDBs and PDBs
    1. Establish a Connection to a CDB/PDB (Exam Objective 3.01)
      1. The Current Container
      2. Common Users and Administrative Tasks
      3. Connecting to the Root Container
      4. Connecting to a PDB
      5. Switching to a Container
    2. Start Up and Shut Down a CDB/PDB (Exam Objective 3.02)
      1. Starting a CDB
      2. PDB Modes and How to Alter Them
      3. Shutting Down a CDB
      4. Opening and Closing PDBs
    3. Change Instance Parameters for a CDB/PDB (Exam Objective 3.03)
      1. Modifying a PDB when Connected to the PDB
      2. Manageability Features in a CDB
      3. Managing Database Objects in a CDB
      4. Viewing Information About CDBs and PDBs
      5. How to Enable a Common User to Access Data in a Specific PDB
      6. Using Views for Monitoring CDBs and PDBs
      7. Querying Container Data Objects
    4. Manage Tablespaces in a CDB/PDB (Exam Objective 3.04)
      1. Creating Tablespaces
      2. Setting the Default Tablespace
      3. Managing Temporary Tablespaces
      4. Modifying a PDB’s Settings
    5. Manage Users and Privileges for CDB/PDB (Exam Objective 3.05)
      1. Managing Users
      2. Managing Privileges
      3. Managing Roles
    6. Two-Minute Drill
    7. Self Test
    8. Self Test Answers
  12. 4: Security New Features
    1. Enable and Configure the Unified Audit Data Trail (Exam Objective 4.01)
      1. How the New Auditing Architecture Works
    2. Create and Enable Audit Policies (Exam Objective 4.02)
      1. Implementing Unified Audit
      2. Creating Audit Policies
      3. Enabling, Disabling, Altering, and Dropping Audit Policies
      4. Capturing Application Context Data
      5. Viewing Audit Policies
    3. Use Task-Specific Administrative Privileges (Exam Objective 4.03)
      1. SYSBACKUP Privilege
      2. SYSDG Privilege
      3. SYSKM Privilege
      4. New Operating System Groups
      5. Support for the New Admin Privileges in the Password File
    4. Create, Enable, and Use Privilege Analysis (Exam Objective 4.04)
      1. Setting the Privilege Analysis Type
      2. Creating the Privilege Analysis Policy
      3. Starting the Privilege Analysis
      4. Privilege Checking During PL/SQL Calls
    5. Use and Manage Oracle Data Redaction Policies (Exam Objective 4.05)
      1. Activities Exempt from Data Redaction
      2. Types of Data Reduction
      3. Defining Redaction Policies
      4. Restrictions on Data Redaction
      5. Adding a Redaction Policy to a Table or View
      6. Modifying a Redaction Policy
      7. How to Exempt Users
      8. Enabling and Disabling Data Redaction Policies
    6. Two-Minute Drill
    7. Self Test
    8. Self Test Answers
  13. 5: Performance Tuning Enhancements
    1. Use Adaptive Execution Plans (Exam Objective 5.01)
      1. Adaptive Query Optimization
      2. Adaptive Statistics
      3. Automatic Reoptimization
      4. SQL Plan Directives
      5. Managing SQL Plan Directives
    2. Use Enhanced Features of Statistics Gathering (Exam Objective 5.02)
      1. Online Statics Gathering for Bulk-Load
      2. Better Concurrent Statistics Gathering
      3. Enhanced Histograms
      4. Collecting Better Extended Statics
    3. Use Adaptive SQL Plan Management (Exam Objective 5.03)
      1. SQL Plan Management
      2. Automatic SPM
      3. New Functions in the DBMS_SPM Package
      4. Configuring the Automatic SPM Evolve Advisor Task
    4. Two-Minute Drill
    5. Self Test
    6. Self Test Answers
  14. 6: Administration and Management New Features
    1. Use Resource Manager for a CDB and a PDB (Exam Objective 6.01)
      1. Managing Resources Between PDBs
      2. CDB Resource Plans and Shares
      3. CDB Resource Plans and Utilization Limits
      4. Creating a CDB Resource Plan
      5. Managing Resources Within a PDB
    2. Multiprocess Multithreaded Architecture and Using Flash Cache (Exam Objective 6.02)
      1. Multiprocess Multithreaded Unix/Linux Architecture
      2. Database Smart Flash Cache
      3. In-memory Parallel Query (PQ) Algorithm
    3. Index and Table Enhancements (Exam Objectives 6.04 and 6.05)
      1. Table Enhancements
      2. Multiple Indexes on the Same Set of Columns
    4. Online Operation Enhancements (Exam Objective 6.06)
      1. Online Redefinition of Tables with VPD
      2. New Online DDL Capabilities
    5. SQL Enhancements
      1. Extended Character Data Type Columns
      2. Using the Database Migration Assistant for Unicode
      3. SecureFiles as Default Storage for Large Objects
      4. SQL Row-Limiting Clause
      5. Advanced Row Compression
    6. Two-Minute Drill
    7. Self Test
    8. Self Test Answers
  15. 7: RMAN Backup and Recovery New Features
    1. Back Up and Recover PDBs and CDBs (Exam Objective 7.01)
      1. Performing Backups
      2. Performing a Recovery with RMAN
    2. Perform Flashback for a CDB (Exam Objective 7.02)
      1. Flashing Back a CDB: An Example
      2. Flashing Back a CDB After a PDB Was Recovered with DBPITR
    3. RMAN Enhancements (Exam Objective 7.03)
      1. New SYBACKUP Administrative Privilege
      2. Using SQL in RMAN
      3. Multisection Backups of Image Copies
      4. RMAN Duplication Enhancements
      5. Transporting Tablespaces and Databases with Backup Sets
      6. Recovering Tables with RMAN’s Table Recovery Feature
    4. New Features in Flashback Data Archive (Exam Objective 7.04)
      1. Flashback Data Archive for Security-Related Application Tables
      2. User-Context Tracking
      3. Hybrid Columnar Compression (HCC)
      4. Import and Export of History
      5. Optimizing the FDA History Tables
    5. Two-Minute Drill
    6. Self Test
    7. Self Test Answers
  16. 8: Storage and Data Loading
    1. Oracle Data Pump Enhancements (Exam Objective 8.01)
      1. Fully Transportable Export and Import of Data
      2. Disabling Logging for Oracle Data Plump Import
      3. Exporting Views as Tables
      4. Compressing Data During an Import
      5. Creating SecureFile LOBs During Import
    2. SQL*Loader and External Table Enhancements (Exam Objective 8.02)
      1. SQL*Loader Express Mode
      2. SQL*Loader Support for Direct-Path Loading of Identity Columns
      3. Syntax Enhancements for SQL*Loader and External Tables
    3. Partitioning Enhancements (Exam Objective 8.03)
      1. Online Partition Operations
      2. Reference Partitioning Enhancements
      3. Multipartition Maintenance Operations
    4. Index Enhancements for Partitioned Tables (Exam Objective 8.04)
      1. Partial Indexes for Partitioned Tables
      2. Asynchronous Global Index Maintenance
      3. New DBMS_PART Package
    5. Two-Minute Drill
    6. Self Test
    7. Self Test Answers
  17. 9: ILM: Automatic Data Optimization, In-Database Archiving, and Temporal Validity
    1. Use ILM Features (Exam Objective 9.01)
    2. Perform Tracking and Automated Data Placement (Exam Objective 9.02)
      1. Automatic Data Optimization
      2. Move a Data File Online
    3. Use In-Database Archiving (Exam Objective 9.03)
      1. Hybrid Columnar Compression
      2. What In-Database Archiving Is
    4. ILM and Temporal Validity (Exam Objective 9.04)
      1. Defining a Valid-Time Dimension
    5. Two-Minute Drill
    6. Self Test
    7. Self Test Answers
  18. Appendix: About the Download
    1. System Requirements
    2. Installing and Running Total Tester
      1. About Total Tester
    3. Technical Support
  19. Glossary
  20. Index