UNIT 1 Preparing for OCP DBA Exam I:SQL and PL/SQL
I Selecting Data from Oracle
Overview of SQL and PL/SQL
Writing Basic SQL Statements
Restricting and Sorting Row Data
Using Single-Row Functions
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
ChapterQuestions
Fill -in-the-BlankAnswers
Answers to Chapter Questions
2 Advanced Data Selection in Oracle
Displaying Data from Multiple Tables
Group Functions and Their Uses
Using Subqueries
Multiple-Column Subqueries
Producing Readable Output with SQL*Plus
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Answers to Chapter
3 Creating Oracle Database Objects
Creating the Tables of an Oracle Database
Including Constraints
The Oracle Data Dictionary
Manipulating Oracle Data
Chapter Summary
Two-Minute Drili
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
4 Creating Other Database Objects in Oracle
Creating Views
Other Database Objects
User Access Control
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
5 Introducing PL/SQL
Overview of PL/SQL
Writing Executable Statements
Writing Control Structures
Interacting with the Oracle Database
Working with Composite Datatypes
Explicit Cursor Handling
Advanced Explicit Cursor Concepts
Error Handling
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
UNIT II
Preparing for OCP DBA Exam 2: Database Administration
6 Basics of the Oraele Database Architecture
Oracle Architectural Components
Getting Started with the Oracle Server
Managing an Oracle Instance
Creating an Oracle Database
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
7 Managing the Physical Database Structure
Data Dictionary Views and Standard Packages
Managing Control Files
Maintaining Redo Log Files
Managing Tablespaces and Datafiles
Storage Structures and Relationships
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
e Managine Database Objects I
Managing Rollback Segments
Managing Tables
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
9 Managing Database Objects II
Managing Indexes
Managing Data Integrity
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
10 Managing Database Use
Managing Users
Managing Password Security and Resources
Managing Privileges
Managing Roles
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
II Data Loads and National Language Support
Loading Data
Reorganizing Data
Using National Language Support
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
UNIT Ⅲ
Preparing for OCP DBA Exam 3: Backup
and Recovery Workshop
12 Overview of Backup and Recovery
Backup and Recovery Considerations
Oracle Recovery Structures and Processes
Oracle Backup and Recovery Configuration
Physical Backups in Oracle Without RMAN
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
13 Database Failure and Recovery
Oracle Utilities for Troubleshooting
Complete Recovery Without RMAN
Oracle Standby Database
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
14 Topics in Data Recovery
Oracle EXPORT and IMPORT Utilities
Incomplete Recovery with Archiving
Additional Oracle Recovery Issues
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
15 Using Recovery Manager for Baekups
Oracle Recovery Manager Overview
Oracle Recovery Catalog Maintenance
Backups Using Recovery Manager
Restoration and Recovery Using RMAN
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
UNIT Ⅳ
Preparing for OCP DBA Exam 4: Performance
Tuning Workshop
16 Introducing Database Tuning
Tuning Overview
Oracle ALERT Logs and Trace Files
Utilities and Dynamic Performance Views
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
17 Tuning Oracle Memory Usage
General Note on Tuning Memory
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning Redo Mechanisms
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
18 Tuning Disk Utilization
Database Configuration and I/O Issues
Tuning Rollback Segments
Using Oracle Blocks Efficiently
Tuning sort Operations
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
19 Tuning Database Applications
Application Requirements and SQL Tuning
Monitoring and Detecting Lock Contention
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
20 Tuning Other Areas of the Oracle Database
Managing a Mixed Workload
Tuning with Oracle Expert
Multithreaded Server Tuning Issues
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
Unit V is found only on the CD-ROM accompanying this book.
UNIT Ⅴ
Preparing for OCP Exam 5: Network Administration
21 Overview of Net8 for Client and Server
22 Oraele Names on MTS
23 Connection Manager, Troubleshooting, and Security
Glossary of Common Oraele Terms
Index