PART II SQL
by Bob Bryla, Roopesh Ramklass, John Watson
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition
- Cover
- Title Page
- Copyright Page
- Dedication
- About the Authors
- Contents
- Introduction
- Part I Getting Started
- Chapter 1 Installing Oracle Database Software
- Chapter 2 Creating an Oracle Database Using DBCA
- Chapter 3 Installing Oracle Grid Infrastructure for a Stand-Alone Server
- Chapter 4 Using Oracle Restart
- PART II SQL
- Chapter 5 DDL and Schema Objects
- Chapter 6 DML and Concurrency
- Describe Each Data Manipulation Language Statement
- Control Transactions
- Explain DML and Undo Data Generation
- Monitor and Administer Undo Data
- Describe the Difference Between Undo Data and Redo Data
- Configure Undo Retention
- Describe the Locking Mechanism and Data Concurrency Management
- Monitor and Resolve Locking Conflicts
- Two-Minute Drill
- Describe Each Data Manipulation Language Statement
- Control Transactions
- Explain DML and Undo Data Generation
- Monitor and Administer Undo Data
- Describe the Difference Between Undo Data and Redo Data
- Configure Undo Retention
- Describe the Locking Mechanism and Data Concurrency Management
- Monitor and Resolve Locking Conflicts
- Self Test
- Self Test Answers
- Chapter 7 Retrieving, Restricting, and Sorting Data Using SQL
- Chapter 8 Single-Row and Conversion Functions
- Chapter 9 Group Functions
- Chapter 10 SQL Joins
- Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
- Join a Table to Itself Using a Self-Join
- View Data That Does Not Meet a Join Condition by Using Outer Joins
- Generate a Cartesian Product of Two or More Tables
- Two-Minute Drill
- Self Test
- Self Test Answers
- Chapter 11 Subqueries and Set Operators
- Define Subqueries
- Describe the Types of Problems that the Subqueries Can Solve
- Describe the Types of Subqueries
- Write Single-Row and Multiple-Row Subqueries
- Describe the Set Operators
- Use a Set Operator to Combine Multiple Queries into a Single Query
- Control the Order of Rows Returned
- Two-Minute Drill
- Self Test
- Self Test Answers
- PART III DBA1
- Chapter 12 Architectural Overview of Oracle Database 12c
- List the Architectural Components of an Oracle Database
- Explain the Memory Structures
- Describe the Background Processes
- SMON, the System Monitor
- PMON, the Process Monitor
- DBWn, the Database Writer
- LGWR, the Log Writer
- CKPT, the Checkpoint Process
- MMON, the Manageability Monitor
- MMNL, the Manageability Monitor Light
- MMAN, the Memory Manager
- LREG, the Listener Registration Process
- ARCn, the Archiver
- RECO, the Recoverer Process
- Some Other Background Processes
- Explain the Relationship Between Logical and Physical Storage Structures
- Two-Minute Drill
- Self Test
- Self Test Answers
- Chapter 13 Instance Management
- Chapter 14 Oracle Networking
- Chapter 15 Oracle Storage
- Describe the Storage of Table Row Data in Blocks
- Create and Manage Tablespaces
- Explain How Oracle Database Server Automatically Manages Space
- Save Space by Using Compression
- Proactively Monitor and Manage Tablespace Space Usage
- Use the Segment Advisor
- Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
- Manage Resumable Space Allocation
- Two-Minute Drill
- Describe the Storage of Table Row Data in Blocks
- Create and Manage Tablespaces
- Explain How Oracle Database Server Automatically Manages Space
- Save Space by Using Compression
- Proactively Monitor and Manage Tablespace Space Usage
- Use the Segment Advisor
- Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
- Manage Resumable Space Allocation
- Self Test
- Self Test Answers
- Chapter 16 Oracle Security
- Chapter 17 Moving and Re-organizing Data
- Describe Ways to Move Data
- Create and Use Directory Objects
- Use SQL*Loader to Load Data from a Non-Oracle Database
- Use External Tables to Move Data via Platform-Independent Files
- Explain the General Architecture of Oracle Data Pump
- Use Data Pump Export and Import to Move Data Between Oracle Databases
- Use Data Pump in a Multitenant Environment
- Use SQL*Loader in a Multitenant Environment
- Two-Minute Drill
- Describe Ways to Move Data
- Create and Use Directory Objects
- Use SQL*Loader to Load Data from a Non-Oracle Database
- Use External Tables to Move Data via Platform-Independent Files
- Explain the General Architecture of Oracle Data Pump
- Use Data Pump Export and Import to Move Data Between Oracle Databases
- Use Data Pump in a Multitenant Environment
- Use SQL*Loader in a Multitenant Environment
- Self Test
- Self Test Answers
- Chapter 18 The AWR and the Alert System
- Chapter 19 Performance Tuning
- Chapter 20 The Resource Manager
- Chapter 21 The Scheduler
- Chapter 12 Architectural Overview of Oracle Database 12c
- Part IV DBA2
- Chapter 22 Configuring the Database for Backup and Recovery
- Chapter 23 Back Up with RMAN
- Chapter 24 Restore and Recover with RMAN
- Perform Complete and Incomplete Recovery
- Restore and Recovery in One Page
- Using the RMAN RESTORE and RECOVER Commands
- Performing Complete Recovery of a Noncritical Datafile
- Performing Complete Recovery of a Critical Datafile
- Performing Incomplete Recovery Using RMAN
- Recovering Using Incrementally Updated Backups
- Switching to Image Copies for Fast Recovery
- Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
- Two-Minute Drill
- Self Test
- Self Test Answers
- Perform Complete and Incomplete Recovery
- Chapter 25 Diagnosing Failures
- Chapter 26 Flashback
- Chapter 27 Duplicating a Database
- Chapter 28 Encrypting, Securing, Monitoring, and Tuning RMAN Backups
- Part V Upgrades and Multitenant
- Chapter 29 Upgrading Oracle Database Software and Migrating Data
- Chapter 30 Upgrading an Oracle Database
- Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
- Use the Pre-Upgrade Information Tool Before Performing an Upgrade
- Prepare the New Oracle Home Prior to Performing an Upgrade
- Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
- Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
- Migrate to Unified Auditing
- Perform Postupgrade Tasks
- Two-Minute Drill
- Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
- Use the Pre-Upgrade Information Tool Before Performing an Upgrade
- Prepare the New Oracle Home Prior to Performing an Upgrade
- Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
- Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
- Migrate to Unified Auditing
- Perform Post-Upgrade Tasks
- Self Test
- Self Test Answers
- Chapter 31 Multitenant Container and Pluggable Database Architecture
- Chapter 32 Creating and Managing Multitenant Container and Pluggable Databases
- Chapter 33 Managing Storage, Security, Availability, and Performance in a CDB and PDBs
- Space Management in a Multitenant Environment
- Manage Common and Local Users, Roles, and Privileges
- Multitenant Backup and Recovery
- Duplicate PDBs Using RMAN
- Mulitenant Performance Monitoring and Tuning
- Manage Allocation of Resources Between PDBs and Within a PDB
- Perform Database Replay
- Two-Minute Drill
- Manage Permanent and Temporary Tablespaces in CDB and PDBs
- Manage Common and Local Users
- Manage Common and Local Privileges
- Manage Common and Local Roles
- Enable Common Users to Access Data in Specific PDBs
- Perform Backups of a CDB and PDBs
- Recover PDB from PDB Datafiles Loss
- Use Data Recovery Advisor
- Duplicate PDBs Using RMAN
- Monitor Operations and Performance in a CDB and PDBs
- Manage Allocation of Resources Between PDBs and Within a PDB
- Perform Database Replay
- Self Test
- Self Test Answers
- Appendix About the Download
- Glossary
- Index
PART II
SQL
Chapter 5 DDL and Schema Objects
Chapter 7 Retrieving, Restricting, and Sorting Data Using SQL
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.