本书是《Oracle技术系统丛书》之一，其具有以下特点：

·涉及5种OCP DBA认证考试的模拟试题及解答：

1ZO-001: SQL and PL/SQL

1ZO-023: Database Administration

1ZO-025: Backup/Recovery

1ZO-024: Tuning

1ZO-026: Net8 Administration

·配套光盘包含实境模拟试题，可帮助应试人员熟悉考试环境，增强取胜信心

目 录 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

n this chapter ,you will learn about and demonstrate knowledge in the following areas:

■ Overview of SQL and PL/SQL

■ Writing basic SQL statements

■ Restricting and sorting row data

■ Using single-row functions

The first exam in the OCP series covers basic areas of database usage and design. Every Oracle use, developer, and DBA should have complete mastery in these areas before moving into other test areas. This unit assumes little or no prior knowledge of Oracle in order to hell you go from never having used Oracle to having enough expertise in the Oracle server product to maintain and enhance existing applications and develop small new ones. The five chapters in this unit will function as the basis for understanding the rest of the book. This chapter will cover sever aspects of data retrieval from the Oracle database, including selecting rows, limiting the selection,and using single-row functions.