OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060)

Name: OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060)
Brand: McGraw-Hill Education
Price: 124.09 EUR
Availability: OnlineOnly

Sam R. Alapati(Autor*in)

McGraw-Hill Education (Verlag)

1. Auflage

Erschienen am 6. Juni 2014

462 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-0-07-181996-1 (ISBN)

124,09 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Als PDF speichern Als Link merken