This book is divided into five units， each covering an exam in the Oracle8i DBA certification track from Oracle. Each unit has several chapters covering the materialyou need to know in order to pass the exam. Within each chapter， there are severalsection discussions. These section discussions correspond directly to subject areastested in the OCP exams. The discussion presents facts about the Oracle database.Commands and keywords that the user enters arepresented in courier， while newterms or emphasized facts are presented in italics. Particularly important facts andsuggestions are set apart from regular text. They are preceded by the word TIP， and a special icon appears in the margin next to them.
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
鄂公網(wǎng)安備 42010302001612號(hào) 