OCP Oracle9i Database：FundamentalsⅠ考试指南：英文版

PREFACE

ACKNOWLEDGMENTS

INTRODUCTION

PART I Preparing for OCP Database Administration Fundamentals I Exam

1 Basics of the Oracle Database Architecture

Oracle Architectural Components

Reading Data form Disk for Users:The Server Process

Structures That Connect Users to Oracle Servers

Stages in Processing Queries,Changes,and commits

Getting Started with the Oracle Server

Common Database Administrative Tools

The Oracle Universal Installer

Benefits of Optimal Flexible Architecture

Setting Up Password File Authentication

Using Oracle Enterprise Manager Components

Managing an Oracle Instance

Creating and Managing Initialization Parameter File

Configuring Oracle-Managed Files(OMF)

Starting an Instance

Monitoring Use of Diagnostic Files

Creating an Oracle Database

Prerequisites for Database Creation

Creating Databases Using Database Configuration Assistant

Creating a Database Manually

Chapter Summary

Two-Minute Drill

Fill-in-the-Blank Questions

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

2 Managing the Physical Database Structure

Data Dicitonary Content and Usage

Constructing the Data Dictionary Views

Key Data Kictiionary Components and Contents

Querying the Data Dictionary

Maintaining Control Files

How Control Files Are Used

Examining Control File Contents

Managing Control Files with Oracle-Managed Files

Obtaining Information about Control Files

Multiplexing Control Files

Maintaining Redo Log Files

The Purpose and Structure of Online Redo Logs

Controlling Log Switches and Checkpoints

Multiplexing and Maintaining Redo Log Files

Managing Online Redo Log Files with OMF

Chapter Summary

Two-Minute Drill

Chapter Questions

Answers to Chapter Questions

3 Managing Tablespaces and Datafiles

Describing the Logical Structure of the Database

Creating Tablespaces

Changing Tablespace Size

Allocating Space for Temporary Segments

Temporary Segments in Permanent Tablespaces

Changing Tablespace Status

Changing Tablespace Storage Settings

Oracle-Managed Files(OMF)

Chapter Summary

Two-Minute Drill

Fill-in-the-Blank Questions

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

4 Storage structures and Undo Data

Storage Structures and Relationships

Different Segment Types and Their Uses

Controlling the Use of Extents by Segments

Using Block Space Utilization Parameters

Obtaining Information about Storage Structures

Managing Undo Data

The Purpose of Undo Segments

Implementing Automatic Undo Management

Creating and Configuring Undo Segments Manually

Obtaining Information about Undo Data

Chapter Summary

Two-Minute Drill

Fill-in-the-Blank Questions

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

5 Managing Database Objects

Managing Tables

Various Methods of Storing Data

Distinguishing Oracle Datatypes

Extended and Restricted ROWIDs

Structure of Data Blocks and Rows

Creating Permanent and Temporary Tables

Managing Storage Structures in a Table

Reorganizing,Truncating,and Dropping Tables

Dropping Unused Columns form Tables

Managing Indexes

Different Index Types and Their Uses

Creating B-Tree and Bitmap Indexes

Reorganizing Indexes

Dropping Indexes

Getting Index Information from the Data Dictionary

Monitoring Use of Indexes

Managing Data Integrity

Implementing Data Integrity Constraints

Maintaining Integrity Constraints

Obtaining Constraint Information from Oracle

Chapter Summary

Two-Minute Drill

Fill-in-the-Blank Questions

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

6 Managing Database Users

Managing Users

Creating New Database Users

Altering and Dropping Existing Users

Monitoring Information about Existing Users

Managing Password Security and Resources

Controlling Resource Use with Profiles

Administering Profiles

Administering Passwords Using Profiles

Obtaining Profile Information form the Data Dictionary

Managing Privileges

Identifying System and Object Privileges

Granting and Revoking Privileges

Identifying Audit Capabilities

Managing Roles

Creating and Modifying Roles

Controlling Availability of Roles

Removing Roles

using Predefined Roles

Displaying Role Informaiton from the Data Dictionary

Chapter Summary

Two-Minute Drill

Fill-in-the-Blank Questions

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

PART II OCP Oracle9i DBA Fundamentals I Practice Exams

7 OCP Database Administration Fundamentals I

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Practice Exam 3

A globalization Support

Choosing a Database and a National Character Set for a Database

Specifying Language-Dependent Behavior

NLS Parameters

Obtaining Information about Globalization Support Usage

Index