Oracle 9i Database考试指南

ACKNOWLEDGMENTS

INTROOUCTION

PART 1

Oracle9i New Features Exam Guide

1 Security Enhancements

Privileged Connections

Deprecation of CONN ECT INTERNAL

Deprecation of Server Manager

Stringent Default Security with the Database Creation

Assistant (DBCA)

Virtual Private Database (VPD)

Policy Management Tool

Secure Application Role

Global Application Context

Multiple Policies

Partitioned Fine-Grained Access Control

Fine-Grained Auditing (FGA)

Audit Column

Audit Event Handler

Enhancements to Encryption

Optional Security Products

Oracle Label Security

Oracle Single Sign-On (SSO)

Oracle Enterprise Login Assistant

Chapter Summary

Two-Minute Drill

Fill-in-the-Blanks

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

2 Availability Enhancements

General High-Availability Technology

Minimal I/O Recovery

Fast-Start Time-Based Recovery Limit

Oracle Flashback

Resumable Space Allocation

Export/Import Features

Data Cuard

A Comprehensive Architectural Framework

Data Availability Modes

Database Role Transitions

Archive Log Gaps

Managed Recovery Process (MRP)

Delayed Redo Logs

Online Operations

Rebuilding Indexes Online

Using Index-Organized Tables (IOTs) Online

Redefining Tables Online.

Validating the Structure with the Online Analyze Command

Using the Server Parameter File (SPFILE)

Replication Enhancements

Adding New Masters Without Quiescing

Row-Level System Change Numbers

Materialized View's Fast Refresh Capability

Object Replication

Job Queue Initialization Parameters

LogMiner

OOL Statement Support

Capability to Use an Online Dictionary

DDL Tracking in the Dictionary

Dictionary Staleness Detection

Capability to Skip Log Corruptions

LogMiner Viewer

Chapter Summary

Two-Minute Drill

Fill-in-the-Blank Questions

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

3 Manageability Enhancements

Database Resource Manager

Automatically Detecting and Preempting Long-Running

Operations

Automatically Limiting Resource Consumption

Segment Management

Automatic Global Index Management

External Tables

List Partitions

Metadata Application Programming Interface (API)

Automatic Segment Space Management

Bitmap join Indexes

Scalable Session Management

The Oracle Shared Server

External Procedure Agents

Multithreaded Heterogeneous Service (HS) Agents

OCI Connection Pooling

The Core Oracle Kernel Library

File Management

Creating and Managing OMFs

Automatically Deleting Non-OMF Files Using SQL

Default Temporary Tablespaces

Tablespace Management

Automatic Undo Management (AUM)

Creating and Managing UNDO Tablespaces

Multiple Block Sizes Within a Database

Database Workspace Management

The Workspace Manager Concept

Creating and Managing Workspaces

The Workspace Administrator Role

Export and Import Considerations for Workspaces

Memory Management

Automatic and Dynamic Sizing of SQL Working Areas

Views and Columns for SQL Execution Memory Management

Allocating and Tracking Memory for Dynamic SGA

Backup and Recovery

Recovery Manager (RMAN) Manageability and Reliability

Enhancements

Trial Recovery

Miscellaneous RMAN Enhancements

Oracle Enterprise Manager (OEM)

New Console Look and Feel

Standalone Mode for the Console

Integrated OEM Functionality

HTML Reports

User Defined Events

Chapter Summary

Two-Minute Drill

Fill - in-the- B1anks

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

4 Performance and Scalability Enhancements

Performance Enhancements

Index Monitoring

Skip Scan Index Access

Cursor Sharing

Cached Execution Plans

First Rows Optimization

Gathering System Statistics

Real Application Clusters (RACs)

Benefits of Orac1e RACs

RAC Architecture

Resource Modes and Resource Roles

Cache Fusion

Shared Server Side Initialization Parameter File

Chapter Summary

Two-Minute Orill

Fill - in-the-Blanks

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

5 Language Enhancements

Enhancements SQL

ISO/ANSI Standardization

Constraints

FOR UPDATE WAIT

LOBs

PL/SQL

Enhancements to Globalization

New Date and Time Datatypes

Enhancements to Unicode

Enhancements to Sorting

The Character Set Scanner

Byte and Character Semantics

The Locale Builder

Chapter Summary

Two-Minute Dri1l

Fill-in-the-Blanks

Chapter Questions

Fill-in-the-Blank Answers

Answers to Chapter Questions

PART II

Oracle9i Certified Professional New Features Practice Exams

6 OCP Oracle9i Upgrade Exam: New Features for Administrators

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Practice Exam 3

Glossary

Index