Cover image for Oracle8i certified professional DBA certification exam guide
Title:
Oracle8i certified professional DBA certification exam guide
Author:
Couchman, Jason S.
Personal Author:
Publication Information:
Berkeley, Calif. ; London : Osborne, [2001]

©2001
Physical Description:
xxxvi, 1156 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.)
General Note:
Includes index.

"213060-1"--Spine.

Covers exams 1Z0-001: SQL and PLISQL, 1Z0-023: database administration, 1Z0-025: backup/recovery, 1Z0-024: tuning, and 1Z0-026: Net8 administration.
Language:
English
Added Author:
ISBN:
9780072130607
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 C675 2001 Book and Software Set Central Closed Stacks
Searching...

On Order

Summary

Summary

This work is an official Oracle certification exam preparation guide. It covers all five exams of the DBA certification and its accompanying CD-ROM is hyperlinked to at least 300 practice exam questions.


Table of Contents

Prefacep. xxi
Acknowledgmentsp. xxv
Introductionp. xxvii
Unit I Preparing for OCP DBA Exam 1: SQL and PL/SQL
1 Selecting Data from Oraclep. 3
Overview of SQL and PL/SQLp. 4
Writing Basic SQL Statementsp. 13
Restricting and Sorting Row Datap. 33
Using Single-Row Functionsp. 37
Chapter Summaryp. 52
Two-Minute Drillp. 55
Fill-in-the-Blanksp. 57
Chapter Questionsp. 57
Fill-in-the-Blank Answersp. 61
Answers to Chapter Questionsp. 61
2 Advanced Data Selection in Oraclep. 65
Displaying Data from Multiple Tablesp. 66
Group Functions and Their Usesp. 75
Using Subqueriesp. 83
Multiple-Column Subqueriesp. 91
Producing Readable Output with SQL*Plusp. 96
Chapter Summaryp. 117
Two-Minute Drillp. 118
Fill-in-the-Blanksp. 122
Chapter Questionsp. 122
Fill-in-the-Blank Answersp. 127
Answers to Chapter Questionsp. 127
3 Creating Oracle Database Objectsp. 131
Creating the Tables of an Oracle Databasep. 132
Including Constraintsp. 145
The Oracle Data Dictionaryp. 159
Manipulating Oracle Datap. 167
Chapter Summaryp. 176
Two-Minute Drillp. 177
Fill-in-the-Blanksp. 181
Chapter Questionsp. 181
Fill-in-the-Blank Answersp. 186
Answers to Chapter Questionsp. 186
4 Creating Other Database Objects in Oraclep. 191
Creating Viewsp. 192
Other Database Objectsp. 200
User Access Controlp. 216
Chapter Summaryp. 222
Two-Minute Drillp. 224
Fill-in-the-Blanksp. 227
Chapter Questionsp. 227
Fill-in-the-Blank Answersp. 231
Answers to Chapter Questionsp. 231
5 Introducing PL/SQLp. 235
Overview of PL/SQLp. 236
Writing Executable Statementsp. 252
Writing Control Structuresp. 258
Interacting with the Oracle Databasep. 269
Working with Composite Datatypesp. 276
Explicit Cursor Handlingp. 286
Advanced Explicit Cursor Conceptsp. 293
Error Handlingp. 298
Chapter Summaryp. 309
Two-Minute Drillp. 311
Fill-in-the-Blanksp. 314
Chapter Questionsp. 314
Fill-in-the-Blank Answersp. 320
Answers to Chapter Questionsp. 320
Unit II Preparing for OCP DBA Exam 2: Database Administration
6 Basics of the Oracle Database Architecturep. 325
Oracle Architectural Componentsp. 326
Getting Started with the Oracle Serverp. 337
Managing an Oracle Instancep. 352
Creating an Oracle Databasep. 366
Chapter Summaryp. 374
Two-Minute Drillp. 377
Fill-in-the-Blanksp. 382
Chapter Questionsp. 382
Fill-in-the-Blank Answersp. 386
Answers to Chapter Questionsp. 386
7 Managing the Physical Database Structurep. 391
Data Dictionary Views and Standard Packagesp. 392
Managing Control Filesp. 401
Maintaining Redo Log Filesp. 407
Managing Tablespaces and Datafilesp. 421
Storage Structures and Relationshipsp. 437
Chapter Summaryp. 449
Two-Minute Drillp. 452
Fill-in-the-Blanksp. 456
Chapter Questionsp. 456
Fill-in-the-Blank Answersp. 461
Answers to Chapter Questionsp. 461
8 Managing Database Objects Ip. 467
Managing Rollback Segmentsp. 468
Managing Tablesp. 483
Chapter Summaryp. 501
Two-Minute Drillp. 502
Fill-in-the-Blanksp. 505
Chapter Questionsp. 505
Fill-in-the-Blank Answersp. 508
Answers to Chapter Questionsp. 508
9 Managing Database Objects IIp. 511
Managing Indexesp. 512
Managing Data Integrityp. 526
Chapter Summaryp. 539
Two-Minute Drillp. 540
Fill-in-the-Blanksp. 542
Chapter Questionsp. 542
Fill-in-the-Blank Answersp. 546
Answers to Chapter Questionsp. 546
10 Managing Database Usep. 549
Managing Usersp. 550
Managing Password Security and Resourcesp. 557
Managing Privilegesp. 566
Managing Rolesp. 583
Chapter Summaryp. 589
Two-Minute Drillp. 591
Fill-in-the-Blanksp. 597
Chapter Questionsp. 597
Fill-in-the-Blank Answersp. 601
Answers to Chapter Questionsp. 601
11 Data Loads and National Language Supportp. 605
Loading Datap. 606
Reorganizing Datap. 621
Using National Language Supportp. 634
Chapter Summaryp. 639
Two-Minute Drillp. 639
Fill-in-the-Blanksp. 641
Chapter Questionsp. 641
Fill-in-the-Blank Answersp. 644
Answers to Chapter Questionsp. 644
Unit III Preparing for OCP DBA Exam 3: Backup and Recovery Workshop
12 Overview of Backup and Recoveryp. 649
Backup and Recovery Considerationsp. 650
Oracle Recovery Structures and Processesp. 662
Oracle Backup and Recovery Configurationp. 679
Physical Backups in Oracle Without RMANp. 692
Chapter Summaryp. 702
Two-Minute Drillp. 703
Fill-in-the-Blanksp. 709
Chapter Questionsp. 709
Fill-in-the-Blank Answersp. 714
Answers to Chapter Questionsp. 714
13 Database Failure and Recoveryp. 719
Oracle Utilities for Troubleshootingp. 720
Complete Recovery Without RMANp. 732
Oracle Standby Databasep. 745
Chapter Summaryp. 756
Two-Minute Drillp. 757
Fill-in-the-Blanksp. 764
Chapter Questionsp. 764
Fill-in-the-Blank Answersp. 768
Answers to Chapter Questionsp. 768
14 Topics in Data Recoveryp. 773
Oracle EXPORT and IMPORT Utilitiesp. 774
Incomplete Recovery with Archivingp. 784
Additional Oracle Recovery Issuesp. 795
Chapter Summaryp. 805
Two-Minute Drillp. 806
Fill-in-the-Blanksp. 811
Chapter Questionsp. 811
Fill-in-the-Blank Answersp. 815
Answers to Chapter Questionsp. 815
15 Using Recovery Manager for Backupsp. 819
Oracle Recovery Manager Overviewp. 820
Oracle Recovery Catalog Maintenancep. 827
Backups Using Recovery Managerp. 840
Restoration and Recovery Using RMANp. 852
Chapter Summaryp. 860
Two-Minute Drillp. 861
Fill-in-the-Blanksp. 865
Chapter Questionsp. 865
Fill-in-the-Blank Answersp. 869
Answers to Chapter Questionsp. 869
Unit IV Preparing for OCP DBA Exam 4: Performance Tuning Workshop
16 Introducing Database Tuningp. 875
Tuning Overviewp. 876
Oracle ALERT Logs and Trace Filesp. 882
Utilities and Dynamic Performance Viewsp. 888
Chapter Summaryp. 917
Two-Minute Drillp. 918
Fill-in-the-Blanksp. 921
Chapter Questionsp. 921
Fill-in-the-Blank Answersp. 924
Answers to Chapter Questionsp. 924
17 Tuning Oracle Memory Usagep. 927
General Note on Tuning Memoryp. 928
Tuning the Shared Poolp. 929
Tuning the Buffer Cachep. 947
Tuning Redo Mechanismsp. 959
Chapter Summaryp. 963
Two-Minute Drillp. 963
Fill-in-the-Blanksp. 967
Chapter Questionsp. 967
Fill-in-the-Blank Answersp. 970
Answers to Chapter Questionsp. 970
18 Tuning Disk Utilizationp. 973
Database Configuration and I/O Issuesp. 974
Tuning Rollback Segmentsp. 989
Using Oracle Blocks Efficientlyp. 998
Tuning Sort Operationsp. 1008
Chapter Summaryp. 1014
Two-Minute Drillp. 1015
Fill-in-the-Blanksp. 1020
Chapter Questionsp. 1020
Fill-in-the-Blank Answersp. 1025
Answers to Chapter Questionsp. 1025
19 Tuning Database Applicationsp. 1029
Application Requirements and SQL Tuningp. 1030
Monitoring and Detecting Lock Contentionp. 1057
Chapter Summaryp. 1069
Two-Minute Drillp. 1069
Fill-in-the-Blanksp. 1072
Chapter Questionsp. 1072
Fill-in-the-Blank Answersp. 1075
Answers to Chapter Questionsp. 1075
20 Tuning Other Areas of the Oracle Databasep. 1077
Managing a Mixed Workloadp. 1078
Tuning with Oracle Expertp. 1088
Multithreaded Server Tuning Issuesp. 1104
Chapter Summaryp. 1110
Two-Minute Drillp. 1110
Fill-in-the-Blanksp. 1116
Chapter Questionsp. 1116
Fill-in-the-Blank Answersp. 1119
Answers to Chapter Questionsp. 1119
Unit V Preparing for OCP Exam 5: Network Administration
21 Overview of Net8 for Client and Server
22 Oracle Names on MTS
23 Connection Manager, Troubleshooting, and Security
Glossary of Common Oracle Termsp. 1123
Indexp. 1137

Google Preview