OCAOCP Oracle Database 11g All In One Exam Guide
OCAOCP%20Oracle%20Database%2011g%20All-in-One%20Exam%20Guide
User Manual:
Open the PDF directly: View PDF
Page Count: 1073 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- Introduction
- Part I: Oracle Database 11g Administration
- Part II: SQL
- Chapter 7 DDL and Schema Objects
- Chapter 8 DML and Concurrency
- Chapter 9 Retrieving, Restricting, and Sorting Data Using SQL
- Chapter 10 Single-Row and Conversion Functions
- Chapter 11 Group Functions
- Chapter 12 SQL Joins
- Exam Objectives
- 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 13 Subqueries and Set Operators
- Exam Objectives
- Define Subqueries
- Describe the Types of Problems That the Subqueries Can Solve
- List 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: Advanced Database Administration
- Chapter 14 Configuring the Database for Backup and Recovery
- Chapter 15 Back Up with RMAN
- Chapter 16 Restore and Recover with RMAN
- Chapter 17 Advanced RMAN Facilities
- Chapter 18 User-Managed Backup, Restore, and Recovery
- Chapter 19 Flashback
- Chapter 20 Automatic Storage Management
- Chapter 21 The Resource Manager
- Chapter 22 The Scheduler
- Chapter 23 Moving and Reorganizing Data
- Chapter 24 The AWR and the Alert System
- Chapter 25 Performance Tuning
- Chapter 26 Globalization
- Chapter 27 The Intelligent Infrastructure
- Appendix About the CD
- Glossary
- Index