You are previewing OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition.
O'Reilly logo
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition

Book Description

This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification.

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam.

  • Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, a score report performance assessment tool, and a PDF copy of the book
  • Ideal as both exam guide and on-the-job reference
  • The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. About the Authors
  6. Contents
  7. Introduction
  8. Part I Getting Started
    1. Chapter 1 Installing Oracle Database Software
      1. Plan for an Oracle Database Software Installation
        1. Supported Platforms
        2. Obtain the Oracle Database Software
        3. User Accounts
        4. Disk Space and Directories
        5. The Prerequisite Checks
      2. Install the Oracle Database Software
        1. The OUI Inventory
        2. The OUI Dialog: Interactive Install
        3. Silent Install and Response Files
        4. Windows and Linux Variations
      3. Two-Minute Drill
        1. Plan for an Oracle Database Software Installation
        2. Install the Oracle Database Software
      4. Self Test
      5. Self Test Answers
    2. Chapter 2 Creating an Oracle Database Using DBCA
      1. Create a Database by Using the Database Configuration Assistant
        1. The Instance, the Database, and the Data Dictionary
        2. Using the Database Configuration Assistant to Create a Database
        3. The DBCA Dialog
      2. Generate Database Creation Scripts by Using DBCA
        1. Generating the Scripts
        2. The Creation Scripts
        3. The Initialization Parameter File
      3. Manage Database Design Templates by Using DBCA
      4. Configure Database Options by Using DBCA
      5. Two-Minute Drill
        1. Create a Database by Using the Database Configuration Assistant
        2. Generate Database Creation Scripts by Using DBCA
        3. Manage Database Design Templates by Using DBCA
        4. Configure Database Options by Using DBCA
      6. Self Test
      7. Self Test Answers
    3. Chapter 3 Installing Oracle Grid Infrastructure for a Stand-Alone Server
      1. Configure Storage for Oracle Automatic Storage Management
        1. GI Architecture
        2. ASM Architecture
        3. ASM Disks
        4. Creating ASM Disks
      2. Install Oracle Grid Infrastructure for a Stand-Alone Server
      3. Two-Minute Drill
        1. Configure Storage for Oracle Automatic Storage Management
        2. Install Oracle Grid Infrastructure for a Stand-Alone Server
      4. Self Test
      5. Self Test Answers
    4. Chapter 4 Using Oracle Restart
      1. Use Oracle Restart to Manage Components
        1. Administering the Oracle Restart Processes
        2. Administering Registered Resources
        3. The Restart Capability
      2. Two-Minute Drill
        1. Use Oracle Restart to Manage Components
      3. Self Test
      4. Self Test Answers
  9. PART II SQL
    1. Chapter 5 DDL and Schema Objects
      1. Use the Client Tools
        1. SQL*Plus
        2. SQL Developer
      2. Categorize the Main Database Objects
        1. Object Types
        2. Users and Schemas
        3. Naming Schema Objects
        4. Object Namespaces
      3. List the Data Types that Are Available for Columns
      4. Create a Simple Table
        1. Creating Tables with Column Specifications
        2. Creating Tables from Subqueries
        3. Altering Table Definitions After Creation
        4. Dropping and Truncating Tables
      5. Create and Use Temporary Tables
      6. Indexes
        1. Why Indexes Are Needed
        2. Types of Indexes
        3. Creating and Using Indexes
        4. Modifying and Dropping Indexes
      7. Constraints
        1. The Types of Constraints
        2. Defining Constraints
        3. Constraint State
        4. Constraint Checking
      8. Views
        1. Why Use Views at All?
        2. Simple and Complex Views
        3. CREATE VIEW, ALTER VIEW, and DROP VIEW
      9. Synonyms
      10. Sequences
        1. Creating Sequences
        2. Using Sequences
      11. Two-Minute Drill
        1. Categorize the Main Database Objects
        2. List the Data Types that Are Available for Columns
        3. Create a Simple Table
        4. Create and Use Temporary Tables
        5. Indexes
        6. Constraints
        7. Views
        8. Synonyms
        9. Sequences
      12. Self Test
      13. Self Test Answers
    2. Chapter 6 DML and Concurrency
      1. Describe Each Data Manipulation Language Statement
        1. INSERT
        2. UPDATE
        3. DELETE
        4. TRUNCATE
        5. MERGE
        6. DML Statement Failures
      2. Control Transactions
        1. Database Transactions
        2. Executing SQL Statements
        3. Transaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATE
      3. Explain DML and Undo Data Generation
      4. Monitor and Administer Undo Data
        1. Error Conditions Related to Undo
        2. Parameters for Undo Management
        3. Sizing and Monitoring the Undo Tablespace
        4. Temporary Undo
        5. Creating and Managing Undo Tablespaces
      5. Describe the Difference Between Undo Data and Redo Data
      6. Configure Undo Retention
        1. Configuring Undo Retention to Support Long-Running Queries
        2. Flashback Query and Undo Retention
      7. Describe the Locking Mechanism and Data Concurrency Management
        1. Shared and Exclusive Locks
        2. The Enqueue Mechanism
        3. Automatic and Manual Locking
      8. Monitor and Resolve Locking Conflicts
        1. The Causes of Lock Contention
        2. Detecting Lock Contention
        3. Solving Lock Contention
        4. Deadlocks: A Special Case
      9. Two-Minute Drill
        1. Describe Each Data Manipulation Language Statement
        2. Control Transactions
        3. Explain DML and Undo Data Generation
        4. Monitor and Administer Undo Data
        5. Describe the Difference Between Undo Data and Redo Data
        6. Configure Undo Retention
        7. Describe the Locking Mechanism and Data Concurrency Management
        8. Monitor and Resolve Locking Conflicts
      10. Self Test
      11. Self Test Answers
    3. Chapter 7 Retrieving, Restricting, and Sorting Data Using SQL
      1. Explain the Capabilities of SQL SELECT Statements
        1. Introducing the SQL SELECT Statement
        2. The DESCRIBE Table Command
        3. Capabilities of the SELECT Statement
      2. Data Normalization
        1. Data Modeling
        2. Entities and Relations
        3. Rows and Tables
        4. Create the Demonstration Schemas
        5. Users and Schemas
        6. The HR and OE Schemas
        7. Demonstration Schema Creation
      3. Execute a Basic SELECT Statement
        1. Syntax of the Primitive SELECT Statement
        2. Rules Are Meant to Be Followed
        3. SQL Expressions and Operators
        4. NULL Is Nothing
      4. Limit the Rows Retrieved by a Query
        1. The WHERE Clause
        2. Comparison Operators
        3. Boolean Operators
        4. Precedence Rules
      5. Sort the Rows Retrieved by a Query
        1. The ORDER BY Clause
        2. The SQL Row-Limiting Clause
      6. Ampersand Substitution
        1. Substitution Variables
        2. Define and Verify
      7. Two-Minute Drill
        1. Explain the Capabilities of SQL SELECT Statements
        2. Execute a Basic SELECT Statement
        3. Limit the Rows Retrieved by a Query
        4. Sort the Rows Retrieved by a Query
        5. Ampersand Substitution
      8. Self Test
      9. Self Test Answers
    4. Chapter 8 Single-Row and Conversion Functions
      1. Describe and Use Character, Number, and Date Functions in SQL
        1. Defining a Function
        2. Types of Functions
        3. Using Case Conversion Functions
        4. Using Character Manipulation Functions
        5. Using Numeric Functions
        6. Working with Dates
      2. Describe Various Types of Conversion Functions Available in SQL
        1. Conversion Functions
      3. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
        1. Using the Conversion Functions
      4. Apply Conditional Expressions in a SELECT Statement
        1. Nested Functions
        2. Conditional Functions
      5. Two-Minute Drill
        1. Describe Various Types of Conversion Functions Available in SQL
        2. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
        3. Apply Conditional Expressions in a SELECT Statement
      6. Self Test
      7. Self Test Answers
    5. Chapter 9 Group Functions
      1. Describe the Group Functions
        1. Definition of Group Functions
        2. Using Group Functions
      2. Group Data Using the GROUP BY Clause
        1. Creating Groups of Data
        2. The GROUP BY Clause
        3. Grouping by Multiple Columns
        4. Nested Group Functions
      3. Include or Exclude Grouped Rows Using the HAVING Clause
        1. Restricting Group Results
        2. The HAVING Clause
      4. Two-Minute Drill
        1. Describe the Group Functions
        2. Group Data Using the GROUP BY Clause
        3. Include or Exclude Grouped Rows Using the HAVING Clause
      5. Self Test
      6. Self Test Answers
    6. Chapter 10 SQL Joins
      1. Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
        1. Types of Joins
        2. Joining Tables Using ANSI SQL Syntax
        3. Qualifying Ambiguous Column Names
        4. The NATURAL JOIN Clause
        5. The JOIN USING Clause
        6. The JOIN ON Clause
        7. N-Way Joins and Additional Join Conditions
        8. Nonequijoins
      2. Join a Table to Itself Using a Self-Join
        1. Joining a Table to Itself Using the JOIN . . . ON Clause
      3. View Data That Does Not Meet a Join Condition by Using Outer Joins
        1. Inner versus Outer Joins
        2. Left Outer Joins
        3. Right Outer Joins
        4. Full Outer Joins
      4. Generate a Cartesian Product of Two or More Tables
        1. Creating Cartesian Products Using Cross Joins
      5. Two-Minute Drill
        1. Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
        2. Join a Table to Itself Using a Self-Join
        3. View Data that Does Not Meet a Join Condition Using Outer Joins
        4. Generate a Cartesian Product of Two or More Tables
      6. Self Test
      7. Self Test Answers
    7. Chapter 11 Subqueries and Set Operators
      1. Define Subqueries
      2. Describe the Types of Problems that the Subqueries Can Solve
        1. Use of a Subquery Result Set for Comparison Purposes
        2. Star Transformation
        3. Generate a Table from Which to SELECT
        4. Generate Values for Projection
        5. Generate Rows to Be Passed to a DML Statement
      3. Describe the Types of Subqueries
        1. Single- and Multiple-Row Subqueries
        2. Correlated Subqueries
      4. Write Single-Row and Multiple-Row Subqueries
        1. Using the EXISTS Condition
        2. Null Results in a Subquery
      5. Describe the Set Operators
        1. Sets and Venn Diagrams
        2. Set Operator General Principles
      6. Use a Set Operator to Combine Multiple Queries into a Single Query
        1. The UNION ALL Operator
        2. The UNION Operator
        3. The INTERSECT Operator
        4. The MINUS Operator
        5. More Complex Examples
      7. Control the Order of Rows Returned
      8. Two-Minute Drill
        1. Define Subqueries
        2. Describe the Types of Problems that the Subqueries Can Solve
        3. Describe the Types of Subqueries
        4. Write Single-Row and Multiple-Row Subqueries
        5. Describe the Set Operators
        6. Use a Set Operator to Combine Multiple Queries into a Single Query
        7. Control the Order of Rows Returned
      9. Self Test
      10. Self Test Answers
  10. PART III DBA1
    1. Chapter 12 Architectural Overview of Oracle Database 12c
      1. List the Architectural Components of an Oracle Database
        1. Single-Instance Database Architecture
        2. Distributed Systems Architectures
      2. Explain the Memory Structures
        1. The Database Buffer Cache
        2. The Log Buffer
        3. The Shared Pool
        4. The Large Pool
        5. The Java Pool
        6. The Streams Pool
      3. Describe the Background Processes
        1. SMON, the System Monitor
        2. PMON, the Process Monitor
        3. DBWn, the Database Writer
        4. LGWR, the Log Writer
        5. CKPT, the Checkpoint Process
        6. MMON, the Manageability Monitor
        7. MMNL, the Manageability Monitor Light
        8. MMAN, the Memory Manager
        9. LREG, the Listener Registration Process
        10. ARCn, the Archiver
        11. RECO, the Recoverer Process
        12. Some Other Background Processes
      4. Explain the Relationship Between Logical and Physical Storage Structures
        1. The Physical Database Structures
        2. The Logical Database Structures
        3. The Data Dictionary
      5. Two-Minute Drill
        1. List the Architectural Components of an Oracle Database
        2. Explain the Memory Structures
        3. Describe the Background Processes
        4. Explain the Relationship Between Logical and Physical Storage Structures
      6. Self Test
      7. Self Test Answers
    2. Chapter 13 Instance Management
      1. Use Database Management Tools
        1. Working with SQL*Plus
        2. Log On as a Normal or Privileged User
        3. Working with Database Express
      2. Understand Initialization Parameter Files
        1. Static and Dynamic Parameter Files
        2. Static and Dynamic Parameters and the Initialization Parameter File
        3. The Basic Parameters
        4. Changing Parameters
      3. Start Up and Shut Down an Oracle Database Instance
        1. Starting the Database Listener
        2. Database Startup and Shutdown
      4. View the Alert Log and Access Dynamic Performance Views
        1. The Alert Log
        2. The DDL Log
        3. The Dynamic Performance Views
      5. Two-Minute Drill
        1. Use Database Management Tools
        2. Understand Initialization Parameter Files
        3. Start Up and Shut Down an Oracle Database Instance
        4. View the Alert Log and Access Dynamic Performance Views
      6. Self Test
      7. Self Test Answers
    3. Chapter 14 Oracle Networking
      1. Configure Oracle Net Services
        1. Oracle Net and the Client-Server Paradigm
        2. Establishing a Session
        3. Creating a Database Listener
        4. Dynamic Service Registration
        5. Shared Server
      2. Use Tools for Configuring and Managing the Oracle Network
        1. The Net Manager
        2. The Net Configuration Assistant
        3. The Listener Control Utility
        4. The TNS_ADMIN Environment Variable
      3. Configure Client-Side Network
        1. Easy Connect Name Resolution
        2. Local Naming Name Resolution
        3. Directory Naming and External Naming
        4. Testing Oracle Net Connectivity
      4. Understand Database Resident Connection Pooling
      5. Configure Communication Between Databases
      6. Two-Minute Drill
        1. Configure Oracle Net Services
        2. Use Tools for Configuring and Managing the Oracle Network
        3. Configure Client-Side Network
        4. Understand Database Resident Connection Pooling
        5. Configure Communication Between Databases
      7. Self Test
      8. Self Test Answers
    4. Chapter 15 Oracle Storage
      1. Describe the Storage of Table Row Data in Blocks
        1. The Oracle Data Storage Model
        2. Segments, Extents, Blocks, and Rows
      2. Create and Manage Tablespaces
        1. Creating Tablespaces
        2. Altering Tablespaces
        3. Dropping Tablespaces
        4. Extent Management
        5. Segment Space Management
        6. Oracle Managed Files
      3. Explain How Oracle Database Server Automatically Manages Space
        1. Segment Space Assignment
        2. Automatic Segment Space Management
      4. Save Space by Using Compression
      5. Proactively Monitor and Manage Tablespace Space Usage
      6. Use the Segment Advisor
      7. Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
      8. Manage Resumable Space Allocation
      9. Two-Minute Drill
        1. Describe the Storage of Table Row Data in Blocks
        2. Create and Manage Tablespaces
        3. Explain How Oracle Database Server Automatically Manages Space
        4. Save Space by Using Compression
        5. Proactively Monitor and Manage Tablespace Space Usage
        6. Use the Segment Advisor
        7. Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
        8. Manage Resumable Space Allocation
      10. Self Test
      11. Self Test Answers
    5. Chapter 16 Oracle Security
      1. Create and Manage Database User Accounts
        1. User Account Attributes
        2. Authentication Methods
        3. Creating Accounts
      2. Grant and Revoke Privileges
        1. System Privileges
        2. Object Privileges
      3. Create and Manage Roles
        1. Creating and Granting Roles
        2. Predefined Roles
        3. Enabling Roles
        4. Privilege Analysis
      4. Create and Manage Profiles
        1. Password Profile Limits
        2. Creating and Assigning Profiles
      5. Explain DBA Responsibilities for Security and Auditing
        1. Reasons for Auditing
        2. Auditing Techniques
      6. Enable Standard Database Auditing and Unified Auditing
        1. Enable Standard Auditing
        2. Enable Unified Auditing
      7. Two-Minute Drill
        1. Create and Manage Database User Accounts
        2. Grant and Revoke Privileges
        3. Create and Manage Roles
        4. Create and Manage Profiles
        5. Explain DBA Responsibilities for Security and Auditing
        6. Enable Standard Database Auditing and Unified Auditing
      8. Self Test
      9. Self Test Answers
    6. Chapter 17 Moving and Re-organizing Data
      1. Describe Ways to Move Data
      2. Create and Use Directory Objects
      3. Use SQL*Loader to Load Data from a Non-Oracle Database
        1. Using SQL*Loader
        2. SQL*Loader Express Mode
      4. Use External Tables to Move Data via Platform-Independent Files
      5. Explain the General Architecture of Oracle Data Pump
      6. Use Data Pump Export and Import to Move Data Between Oracle Databases
        1. Capabilities
        2. Using Data Pump with the Command-Line Utilities
        3. Tablespace Export and Import
      7. Use Data Pump in a Multitenant Environment
        1. Export from Non-CDB and Import into PDB
        2. Export and Import Between PDBs
        3. Export from PDB and Import into Non-CDB
        4. Full Transportable Export and Import
        5. Transporting a Database Over the Network
      8. Use SQL*Loader in a Multitenant Environment
      9. Two-Minute Drill
        1. Describe Ways to Move Data
        2. Create and Use Directory Objects
        3. Use SQL*Loader to Load Data from a Non-Oracle Database
        4. Use External Tables to Move Data via Platform-Independent Files
        5. Explain the General Architecture of Oracle Data Pump
        6. Use Data Pump Export and Import to Move Data Between Oracle Databases
        7. Use Data Pump in a Multitenant Environment
        8. Use SQL*Loader in a Multitenant Environment
      10. Self Test
      11. Self Test Answers
    7. Chapter 18 The AWR and the Alert System
      1. Manage the Automatic Workload Repository
        1. Gathering AWR Statistics
        2. Managing the AWR
      2. Use the Automatic Database Diagnostic Monitor
      3. Describe and Use the Advisory Framework
        1. The Memory Advisors
        2. The SQL Advisors
        3. The Automatic Undo Advisor
        4. The Mean Time to Recover Advisor
        5. The Data Recovery Advisor
        6. The Segment Advisor
        7. The SQL Repair Advisor
      4. Set Alert Thresholds
        1. Alert Condition Monitoring and Notifications
        2. Setting Thresholds
      5. Use Automated Tasks
        1. The Autotasks
        2. Controlling the Autotasks
      6. Two-Minute Drill
        1. Manage the Automatic Workload Repository
        2. Use the Automatic Database Diagnostic Monitor
        3. Describe and Use the Advisory Framework
        4. Set Alert Thresholds
        5. Use Automated Tasks
      7. Self Test
      8. Self Test Answers
    8. Chapter 19 Performance Tuning
      1. Use Enterprise Manager to Monitor Performance
        1. A Performance Tuning Methodology
        2. Performance Monitoring Data
        3. The Database Express Performance Pages
      2. Use Automatic Memory Management
        1. PGA Memory Management
        2. SGA Memory Management
        3. Automatic Memory Management
      3. Use the Memory Advisor to Size Memory Buffers
      4. Manage Optimizer Statistics
        1. Object Statistics
        2. How the Optimizer Uses Statistics
        3. Gathering Statistics Manually
      5. Use the SQL Tuning Advisor
        1. The Capabilities of the SQL Tuning Advisor
        2. The SQL Tuning Advisor API: The DBMS_SQLTUNE Package
      6. Use the SQL Access Advisor to Tune Workload
        1. The Capabilities of the SQL Access Advisor
        2. Using the SQL Access Advisor with DBMS_ADVISOR
      7. Two-Minute Drill
        1. Use Enterprise Manager to Monitor Performance
        2. Use Automatic Memory Management
        3. Use the Memory Advisor to Size Memory Buffers
        4. Manage Optimizer Statistics
        5. Use the SQL Tuning Advisor
        6. Use the SQL Access Advisor to Tune Workload
      8. Self Test
      9. Self Test Answers
    9. Chapter 20 The Resource Manager
      1. Configure the Database Resource Manager
        1. The Need for Resource Management
        2. The Resource Manager Architecture
        3. Resource Manager Configuration
      2. Access and Create Resource Plans
        1. CPU Method
        2. Use of the Ratio CPU Method
        3. The Active Session Pool Method
        4. Limiting the Degree of Parallelism
        5. Controlling Jobs by Execution Time
        6. Terminating Sessions by Idle Time
        7. Restricting Generation of Undo Data
      3. Monitor the Resource Manager
      4. Two-Minute Drill
        1. Configure the Database Resource Manager
        2. Access and Create Resource Plans
        3. Monitor the Resource Manager
      5. Self Test
      6. Self Test Answers
    10. Chapter 21 The Scheduler
      1. Use Oracle Scheduler to Simplify Management Tasks
        1. The Scheduler Architecture
        2. Scheduler Objects
      2. Use Job Chains to Perform a Series of Related Tasks
      3. Use Scheduler Jobs on Remote Systems
      4. Use Advanced Scheduler Features to Prioritize Jobs
        1. Using Job Classes
        2. Using Windows
      5. Two-Minute Drill
        1. Use Oracle Scheduler to Simplify Management Tasks
        2. Use Job Chains to Perform a Series of Related Tasks
        3. Use Scheduler Jobs on Remote Systems
        4. Use Advanced Scheduler Features to Prioritize Jobs
      6. Self Test
      7. Self Test Answers
  11. Part IV DBA2
    1. Chapter 22 Configuring the Database for Backup and Recovery
      1. Possible Failures and Their Resolution
        1. Failure Categories
        2. Oracle Backup and Recovery Solutions
        3. Instance Recovery and the Impossibility of Database Corruption
      2. Checkpoints and the Redo Log
        1. The Checkpointing Mechanism
        2. Protecting the Online Redo Log Files
        3. Archivelog Mode and the Archiver Processes
      3. Backup and Recovery: Configuration
      4. Configure the Fast Recovery Area
      5. Configure ARCHIVELOG Mode
      6. Two-Minute Drill
        1. Possible Failures and Their Resolution
        2. Checkpoints and the Redo Log
        3. Configure the Fast Recovery Area
        4. Configure ARCHIVELOG Mode
        5. Configure Control Files and Redo Log Files for Recoverability
      7. Self Test
      8. Self Test Answers
    2. Chapter 23 Back Up with RMAN
      1. Backup Theory and Basic Syntax
        1. Backup Concepts
        2. RMAN Basic Syntax
        3. Persistent RMAN Settings
      2. Some Advanced RMAN Capabilities
        1. The Recovery Catalog
        2. Create and Use RMAN Stored Scripts
        3. Incremental Backups
        4. Other Capabilities
      3. Two-Minute Drill
        1. Create Consistent Database Backups
        2. Back Up Your Database Without Shutting It Down
        3. Create Incremental Backups
        4. Automate Database Backups
        5. Manage Backups and the RMAN Repository
        6. Use Various RMAN Backup Types and Strategies
        7. Perform Full and Incremental Backups
        8. Use Techniques to Improve Backups
      4. Self Test
      5. Self Test Answers
    3. Chapter 24 Restore and Recover with RMAN
      1. Perform Complete and Incomplete Recovery
        1. Restore and Recovery in One Page
        2. Using the RMAN RESTORE and RECOVER Commands
        3. Performing Complete Recovery of a Noncritical Datafile
        4. Performing Complete Recovery of a Critical Datafile
        5. Performing Incomplete Recovery Using RMAN
        6. Recovering Using Incrementally Updated Backups
        7. Switching to Image Copies for Fast Recovery
      2. Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
        1. Restoring the Spfile from the Autobackup
        2. Restoring the Controlfile
        3. Recovering from a Lost Redo Log Group
        4. Backing Up and Restoring the Password File
        5. Recovering from a Lost Tempfile
      3. Two-Minute Drill
        1. Perform Complete and Incomplete Recovery
        2. Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
        3. Perform Recovery of Tempfiles
      4. Self Test
      5. Self Test Answers
    4. Chapter 25 Diagnosing Failures
      1. Describe the Automatic Diagnostic Workflow
        1. Understanding the ADR
        2. Using the ADRCI Tool
        3. Understanding Alerts, Problems, and Incidents
        4. Using the Health Monitor
      2. Handle Block Corruption
        1. Block Corruption
        2. Using Block Media Recovery
        3. Using the Data Recovery Advisor
      3. Two-Minute Drill
        1. Describe the Automatic Diagnostic Workflow
        2. Handle Block Corruption
      4. Self Test
      5. Self Test Answers
    5. Chapter 26 Flashback
      1. Describe the Flashback Technologies
        1. Flashback Database
        2. Flashback Query, Transaction, and Table
        3. Flashback Drop
        4. Flashback Data Archive
        5. When to Use Flashback Technology
      2. Use Flashback to Query Data
        1. Basic Flashback Query
        2. Flashback Table Query
        3. Flashback Versions Query
        4. Flashback Transaction Query
        5. Flashback and Undo Data
      3. Perform Flashback Table Drop Operations
        1. The Implementation of Flashback Drop
        2. Using Flashback Drop
        3. Managing the Recycle Bin
      4. Perform Table Recovery from Backups
      5. Describe and Use Flashback Data Archive
      6. Perform Flashback Database
        1. Flashback Database Architecture
        2. Configuring Flashback Database
        3. Monitoring Flashback Database
        4. Using Flashback Database
      7. Two-Minute Drill
        1. Describe the Flashback Technologies
        2. Use Flashback to Query Data
        3. Perform Flashback Table Operations
        4. Perform Table Recovery from Backups
        5. Describe and Use Flashback Data Archive
        6. Perform Flashback Database
      8. Self Test
      9. Self Test Answers
    6. Chapter 27 Duplicating a Database
      1. Describe and Use Transportable Tablespaces and Databases
        1. Configuring Transportable Tablespaces
        2. Transporting Tablespaces
        3. Transporting a Database
      2. Duplicate a Database
        1. Using a Duplicate Database
        2. Duplicate from the Active Database
        3. Duplicate from Backup
      3. Two-Minute Drill
        1. Describe and Use Transportable Tablespaces and Databases
        2. Choose a Technique for Duplicating a Database
        3. Create a Backup-Based Duplicate Database
        4. Duplicate a Database
      4. Self Test
      5. Self Test Answers
    7. Chapter 28 Encrypting, Securing, Monitoring, and Tuning RMAN Backups
      1. Create RMAN-Encrypted Backups
        1. Configuring and Using Transparent Encryption
        2. Using Password Encryption
        3. Using Dual-Mode Encryption
      2. Configure and Use Oracle Secure Backup
        1. Installing and Configuring Oracle Secure Backup
        2. Using RMAN with Oracle Secure Backup
        3. Miscellaneous obtool Commands
      3. Monitor and Tune RMAN Performance
        1. Monitoring RMAN Sessions and Jobs
        2. Tuning RMAN Performance
        3. Identifying Backup and Restore Steps
        4. Parallelizing Backupsets
        5. Understanding RMAN Multiplexing
        6. Tuning RMAN Channels
        7. Tuning the BACKUP Command
      4. Two-Minute Drill
        1. Create RMAN-Encrypted Backups
        2. Configure and Use Oracle Secure Backup
        3. Tune RMAN Performance
      5. Self Test
      6. Self Test Answers
  12. Part V Upgrades and Multitenant
    1. Chapter 29 Upgrading Oracle Database Software and Migrating Data
      1. Describe Upgrade Methods
        1. Software Upgrade
        2. Database Upgrade: DBUA or Manual
      2. Describe Data Migration Methods
      3. Describe the Upgrade Process
      4. Migrate Data by Using Oracle Data Pump
      5. Two-Minute Drill
        1. Describe Upgrade Methods
        2. Describe Data Migration Methods
        3. Describe the Upgrade Process
        4. Migrate Data by Using Oracle Data Pump
      6. Self Test
      7. Self Test Answers
    2. Chapter 30 Upgrading an Oracle Database
      1. Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
        1. Oracle Label Security and Oracle Data Vault
        2. Oracle Warehouse Builder
      2. Use the Pre-Upgrade Information Tool Before Performing an Upgrade
      3. Prepare the New Oracle Home Prior to Performing an Upgrade
      4. Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
      5. Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
      6. Migrate to Unified Auditing
      7. Perform Postupgrade Tasks
      8. Two-Minute Drill
        1. Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
        2. Use the Pre-Upgrade Information Tool Before Performing an Upgrade
        3. Prepare the New Oracle Home Prior to Performing an Upgrade
        4. Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
        5. Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
        6. Migrate to Unified Auditing
        7. Perform Post-Upgrade Tasks
      9. Self Test
      10. Self Test Answers
    3. Chapter 31 Multitenant Container and Pluggable Database Architecture
      1. Describe the Multitenant Container Database Architecture
        1. Multitenant Concepts
        2. The Drivers for Multitenant
        3. The CDB and the Root Container
        4. PDBs: Pluggable Containers
      2. Explain Pluggable Database Provisioning
        1. Techniques for Provisioning Pluggable Containers
        2. Communications Between Containers
      3. Two-Minute Drill
        1. Describe the Multitenant Container Database Architecture
        2. Explain Pluggable Database Provisioning
      4. Self Test
      5. Self Test Answers
    4. Chapter 32 Creating and Managing Multitenant Container and Pluggable Databases
      1. Create a Container Database
        1. Use DBCA to Create a CDB
        2. Using SQL*Plus to Create a CDB
      2. Create Pluggable Containers
        1. Using PDB$SEED to Create a New PDB
        2. Cloning a PDB to Create a New PDB
        3. Plug a Non-CDB into a CDB
        4. Plug an Unplugged PDB into a CDB
        5. Unplug and Drop a PDB
      3. Migrate a Pre-12.1 Non-CDB Database to CDB
      4. Establish Connections to CDBs and PDBs
        1. Understanding CDB and PDB Service Names
        2. Creating Services for CDBs or PDBs
        3. Switching Connections Within a CDB
      5. Start Up and Shut Down a CDB and Open and Close PDBs
        1. CDB Instance Startup
        2. Open and Close a PDB
        3. CDB Instance Shutdown
        4. Automating PDB Startup
        5. Changing PDB Status
      6. Evaluate the Impact of Parameter Value Changes
        1. Understanding the Scope of Parameter Changes
        2. Using ALTER SYSTEM in a Multitenant Environment
      7. Two-Minute Drill
        1. Create a Container Database
        2. Create Pluggable Containers
        3. Migrate a Pre-12.1 Non-CDB Database to CDB
        4. Establish Connections to CDBs and PDBs
        5. Start Up and Shut Down a CDB and Open and Close PDBs
        6. Evaluate the Impact of Parameter Value Changes
      8. Self Test
      9. Self Test Answers
    5. Chapter 33 Managing Storage, Security, Availability, and Performance in a CDB and PDBs
      1. Space Management in a Multitenant Environment
        1. Tablespace Architecture
        2. Using CREATE TABLESPACE
        3. Default Permanent and Temporary Tablespaces in a PDB
      2. Manage Common and Local Users, Roles, and Privileges
        1. Common and Local Users
        2. Grant Privileges Commonly and Locally
        3. Manage Common and Local Roles
        4. Enable Common Users to Access Data in Specific PDBs
        5. Audit in the Multitenant Environment
      3. Multitenant Backup and Recovery
        1. Back Up a CDB and Individual PDBs
        2. Restore and Recovery
      4. Duplicate PDBs Using RMAN
      5. Mulitenant Performance Monitoring and Tuning
        1. Tuning the Instance
        2. Using Memory Advisors
      6. Manage Allocation of Resources Between PDBs and Within a PDB
        1. Using Shares to Manage Inter-PDB Resources
        2. Creating and Modifying Resource Manager Plans
      7. Perform Database Replay
        1. Capture Source Database Workloads
        2. Process Workloads on the Target System
        3. Replay Workloads on Target CDB: Consolidated Replay
      8. Two-Minute Drill
        1. Manage Permanent and Temporary Tablespaces in CDB and PDBs
        2. Manage Common and Local Users
        3. Manage Common and Local Privileges
        4. Manage Common and Local Roles
        5. Enable Common Users to Access Data in Specific PDBs
        6. Perform Backups of a CDB and PDBs
        7. Recover PDB from PDB Datafiles Loss
        8. Use Data Recovery Advisor
        9. Duplicate PDBs Using RMAN
        10. Monitor Operations and Performance in a CDB and PDBs
        11. Manage Allocation of Resources Between PDBs and Within a PDB
        12. Perform Database Replay
      9. Self Test
      10. Self Test Answers
  13. Appendix About the Download
    1. System Requirements
      1. Installing and Running Total Tester
      2. About Total Tester
    2. Technical Support
  14. Glossary
  15. Index