OCP Oracle9i Database New Features for Administrators - Exam Guide

Name: OCP Oracle9i Database New Features for Administrators - Exam Guide
Price: 5.7 USD
Availability: InStock
ISBN: 9780072195309

ISBN-10: 0072195304

ISBN-13: 9780072195309

Edition: 2002

Authors: Daniel K. Benjamin

List price: $49.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $5.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

This guide includes two minute drills at the end of each chapter to quiz readers' retention of iinformation presented in the chapters. The book also contains practice questions and self tests.

Book details

List price: $49.99
Copyright year: 2002
Publisher: McGraw-Hill Osborne
Binding: Mixed Media
Pages: 432
Size: 7.75" wide x 9.25" long x 0.75" tall
Weight: 1.936
Language: English

Acknowledgments	p. xvii
Introduction	p. xix
Oracle9i New Features Exam Guide
Security Enhancements	p. 3
Privileged Connections	p. 5
Deprecation of Connect Internal	p. 5
Deprecation of Server Manager	p. 6
Stringent Default Security with the Database Creation Assistant (DBCA)	p. 7
Virtual Private Database (VPD)	p. 10
Policy Management Tool	p. 11
Secure Application Role	p. 11
Global Application Context	p. 15
Multiple Policies	p. 19
Partitioned Fine-Grained Access Control	p. 19
Fine-Grained Auditing (FGA)	p. 21
Audit Column	p. 23
Audit Event Handler	p. 24
Enhancements to Encryption	p. 25
Optional Security Products	p. 25
Oracle Label Security	p. 26
Oracle Single Sign-On (SSO)	p. 26
Oracle Enterprise Login Assistant	p. 27
Chapter Summary	p. 29
Two-Minute Drill	p. 31
Fill-in-the-Blanks	p. 34
Chapter Questions	p. 35
Fill-in-the-Blank Answers	p. 37
Answers to Chapter Questions	p. 37
Availability Enhancements	p. 41
General High-Availability Technology	p. 42
Minimal I/O Recovery	p. 42
Fast-Start Time-Based Recovery Limit	p. 43
Oracle Flashback	p. 45
Resumable Space Allocation	p. 47
Export/Import Features	p. 49
Data Guard	p. 51
A Comprehensive Architectural Framework	p. 53
Data Availability Modes	p. 55
Database Role Transitions	p. 64
Archive Log Gaps	p. 71
Managed Recovery Process (MRP)	p. 72
Delayed Redo Logs	p. 73
Online Operations	p. 74
Rebuilding Indexes Online	p. 75
Using Index-Organized Tables (IOTs) Online	p. 76
Redefining Tables Online	p. 78
Validating the Structure with the Online Analyze Command	p. 80
Using the Server Parameter File (SPFILE)	p. 80
Replication Enhancements	p. 83
Adding New Masters Without Quiescing	p. 85
Row-Level System Change Numbers	p. 93
Materialized View's Fast Refresh Capability	p. 94
Object Replication	p. 97
Job Queue Initialization Parameters	p. 99
LogMiner	p. 100
DDL Statement Support	p. 101
Capability to Use an Online Dictionary	p. 102
DDL Tracking in the Dictionary	p. 103
Dictionary Staleness Detection	p. 103
Capability to Skip Log Corruptions	p. 103
LogMiner Viewer	p. 104
Chapter Summary	p. 110
Two-Minute Drill	p. 111
Fill-in-the-Blank Questions	p. 114
Chapter Questions	p. 115
Fill-in-the-Blank Answers	p. 117
Answers to Chapter Questions	p. 118
Manageability Enhancements	p. 121
Database Resource Manager	p. 122
Automatically Detecting and Preempting Long-Running Operations	p. 123
Automatically Limiting Resource Consumption	p. 123
Segment Management	p. 129
Automatic Global Index Management	p. 130
External Tables	p. 131
List Partitions	p. 134
Metadata Application Programming Interface (API)	p. 136
Automatic Segment Space Management	p. 138
Bitmap Join Indexes	p. 142
Scalable Session Management	p. 144
The Oracle Shared Server	p. 144
External Procedure Agents	p. 146
Multithreaded Heterogeneous Service (HS) Agents	p. 148
OCI Connection Pooling	p. 150
The Core Oracle Kernel Library	p. 152
File Management	p. 153
Creating and Managing OMFs	p. 153
Automatically Deleting Non-OMF Files Using SQL	p. 157
Default Temporary Tablespaces	p. 158
Tablespace Management	p. 160
Automatic Undo Management (AUM)	p. 160
Creating and Managing UNDO Tablespaces	p. 161
Multiple Block Sizes Within a Database	p. 164
Database Workspace Management	p. 166
The Workspace Manager Concept	p. 167
Creating and Managing Workspaces	p. 168
The Workspace Administrator Role	p. 174
Export and Import Considerations for Workspaces	p. 175
Memory Management	p. 176
Automatic and Dynamic Sizing of SQL Working Areas	p. 177
Views and Columns for SQL Execution Memory Management	p. 178
Allocating and Tracking Memory for Dynamic SGA	p. 180
Backup and Recovery	p. 182
Recovery Manager (RMAN) Manageability and Reliability Enhancements	p. 183
Trial Recovery	p. 186
Miscellaneous RMAN Enhancements	p. 187
Oracle Enterprise Manager (OEM)	p. 189
New Console Look and Feel	p. 189
Standalone Mode for the Console	p. 190
Integrated OEM Functionality	p. 194
HTML Reports	p. 199
User-Defined Events	p. 200
Chapter Summary	p. 201
Two-Minute Drill	p. 202
Fill-in-the-Blanks	p. 205
Chapter Questions	p. 206
Fill-in-the-Blank Answers	p. 208
Answers to Chapter Questions	p. 209
Performance and Scalability Enhancements	p. 211
Performance Enhancements	p. 212
Index Monitoring	p. 212
Skip Scan Index Access	p. 214
Cursor Sharing	p. 215
Cached Execution Plans	p. 217
First Rows Optimization	p. 218
Gathering System Statistics	p. 220
Real Application Clusters (RACs)	p. 223
Benefits of Oracle RACs	p. 223
RAC Architecture	p. 224
Resource Modes and Resource Roles	p. 225
Cache Fusion	p. 226
Shared Server-Side Initialization Parameter File	p. 227
Chapter Summary	p. 230
Two-Minute Drill	p. 231
Fill-in-the-Blanks	p. 234
Chapter Questions	p. 235
Fill-in-the-Blank Answers	p. 237
Answers to Chapter Questions	p. 237
Language Enhancements	p. 241
Enhancements SQL	p. 242
ISO/ANSI Standardization	p. 242
Constraints	p. 259
For Update Wait	p. 261
LOBs	p. 262
PL/SQL	p. 263
Enhancements to Globalization	p. 266
New Date and Time Datatypes	p. 267
Enhancements to Unicode	p. 271
Enhancements to Sorting	p. 272
The Character Set Scanner	p. 273
Byte and Character Semantics	p. 275
The Locale Builder	p. 276
Chapter Summary	p. 278
Two-Minute Drill	p. 279
Fill-in-the-Blanks	p. 282
Chapter Questions	p. 283
Fill-in-the-Blank Answers	p. 284
Answers to Chapter Questions	p. 285
Oracle9i Certified Professional New Features Practice Exams
OCP Oracle9i Upgrade Exam: New Features for Administrators	p. 289
Practice Exam 1	p. 290
Practice Exam 2	p. 304
Practice Exam 3	p. 319
Answers to Practice Exam 1	p. 333
Answers to Practice Exam 2	p. 343
Answers to Practice Exam 3	p. 353
Glossary	p. 365
Index	p. 383
Table of Contents provided by Syndetics. All Rights Reserved.