OCP Oracle9i Database New Features for Administrators考试指南(英文版,附光盘)

This book meets the objectives set forth for the Oracle9i New Features for Administrators 1Z0-030 exam, to upgrade your OCP certification from Oracle8i to Oracle9i. As such, this book is an excellent tool to prepare for the exam. Besides the technical discussions, Part 1 has many aids to help you prepare for the exam. At the end of topics you will find a For Review section and a number of questions to confirm and retain your learning. At the end of chapters, you will find a good summary that will help you review the chapter, and a number of questions. Part 2 consists of 3 practice exams with a total of 180 questions. You can purchase additional Practice tests from Oracle Corporation (see following instructions). When you take the exam, you will have to answer correctly at least 38 questions out of a total of 56 in order to successfully complete the exam. The required number of correct questions can vary based on the difficulty of the questions administered in the particular exam you take.

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

This book is a valuable resource for IT Management and Technical Staff; it gives them a good insight into the many enhancements in Oracle9i to address the challenges introduced by the Internet. The database has to service millions of users from around the world without compromising security even though many of the users are anonymous, without degrading performance levels, and while letting each user have a personal experience in the time and language of their locale. You have to improve availability, because downtime can have significant..