1 OCP Exam 1:Introduction to SQL and PL/SQL 3
1 OCP Exam 1:Introduction to SQLand PL/SQL 3
PART I OCP Oracle8i DBA Practice Exams 3
PART I OCP Oracle8i DBA Practice Exams 3
OCP Exam 1 Topic Areas 4
Practice Exam 1 9
FOREWORD 17
ACKNOWLEDGMENTS 19
INTRODUCTION 21
Practice Exam 2 27
Practice Exam 3 50
Answers to Practice Exam 1 67
Answers to Practice Exam 2 80
Answers to Practice Exam 3 94
2 OCP Exam 2:Database Administration 107
2 OCP Exam 2:Database Administration 107
OCP Exam 2 Topic Areas 108
Practice Exam 1 113
Practice Exam 2 130
Practice Exam 3 146
Answers to Practice Exam 1 163
Answers to Practice Exam 2 177
Answers to Practice Exam 3 191
3 OCP Exam 3:Backup and Recovery Workshop 207
3 OCP Exam 3:Backup and Recovery Workshop 207
OCP Exam 3 Topic Areas 208
Practice Exam 1 212
Practice Exam 2 228
Practice Exam 3 244
Answers to Practice Exam 1 260
Answers to Practice Exam 2 274
Answers to Practice Exam 3 287
4 OCP Exam 4:Performance Tuning Workshop 303
4 OCP Exam 4:Performance Tuning Workshop 303
OCP Exam 4 Topic Areas 304
Practice Exam 1 308
Practice Exam 2 324
Practice Exam 3 340
Answers to Practice Exam 1 356
Answers to Practice Exam 2 371
Answers to Practice Exam 3 385
5 OCP Exam 5:Network Administration 401
5 OCP Exam 5:Network Administration 401
OCP Exam 5 Topic Areas 402
Practice Exam 1 405
Practice Exam 2 418
Practice Exam 3 432
Answers to Practice Exam 1 445
Answers to Practice Exam 2 457
Answers to Practice Exam 3 468
PART II OCP Key Terms and Concepts 483
6 OCP Exam I Terms and Concepts 483
6 OCP Exam 1 Terms and Concepts 483
PART II OCP Key Terms and Concepts 483
Overview of Relational Databases,SQL,and PL/SQL 484
Writing Basic SQL Statements 485
Restricting and Sorting Data 486
Single-Row Functions 486
Displaying Data from Multiple Tables 487
Subqueries 488
Aggregating Data Using Group Functions 488
Multiple-Column Subqueries 489
Producing Readable Output from SQL*Plus 489
Manipulating Data 490
Creating and Managing Tables 490
Including Constraints 491
Creating Views 492
Other Database Objects 494
Oracle Data Dictionary 494
Controlling User Access 496
Declaring Variables 496
Write Executable Statements 497
Interacting with the Oracle Server 497
Writing Control Structures 498
Working with Composite Datatypes 498
Writing Explicit Cursors 499
Advanced Explicit Cursor Concepts 500
Handling Exceptions 500
Fill-In-the-Blanks 501
Fill-In-the-Blank Answers 504
7 OCP Exam 2 Terms and Concepts 507
7 OCP Exam 2 Terms and Concepts 507
Oracle Architectural Components 508
Getting Started with Oracle Server 509
Managing an Oracle Instance 510
Creating a Database 512
Data Dictionary Views and Standard Packages 514
Maintaining the Control File 515
Maintaining Redo Log Files 515
Managing Tablespaces and Datafiles 516
Storage Structures and Relationships 518
Managing Rollback Segments 518
Managing Tables 519
Managing Indexes 521
Maintaining Data Integrity 522
Loading Data 522
Reorganizing Data 524
Managing Password Security and Resources 525
Managing Users 526
Managing Privileges 526
Managing Roles 529
Using National Language Support 530
Fill-in-the-Blanks 531
Fill-in-the-Blank Answers 533
8 OCP Exam 3 Terms and Concepts 535
8 OCP Exam 3 Terms and Concepts 535
Backup and Recovery Considerations 536
Oracle Recovery Structures and Processes 537
Oracle Backup and Recovery Configuration 537
Physical Backups Without Oracle Recovery Manager 538
Oracle Recovery Without Recovery Manager 540
Incomplete Oracle Recovery with Archiving 543
Oracle Export and Import Utilities 544
Additional Oracle Recovery Issues 545
Oracle Utilities for Troubleshooting 546
Oracle Recovery Manager Overview 548
Oracle Recovery Catalog Creation and Maintenance 549
Backups Using RMAN 550
Restoration and Recovery Using RMAN 550
Oracle Standby Database 552
Fill-in-the-Blanks 554
Fill-in-the-Blank Answers 555
9 OCP Exam 4 Terms and Concepts 557
9 OCP Exam 4 Terms and Concepts 557
Tuning Overview 558
Oracle Alert and Trance Files 558
Usage and Configuration of Connection Manager 558
Utilities and Dynamic Performance Views 559
Tuning the Shared Pool 560
Tuning the Buffer Cache 561
Tuning the Redo Log Buffer 563
Database Configuration and I/O Issues 563
Using Oracle Blocks Efficiently 565
Optimize Sort Operations 566
Rollback Segment Tuning 567
SQL Issues and Tuning Considerations for Different Applications 568
Monitoring and Detecting Lock Contention 568
Managing a Mixed Workload 573
Tuning with Oracle Expert 575
Multithreaded Server Tuning Issues 576
Fill-in-the-Blanks 578
Fill-in-the-Blank Answers 579
10 OCP Exam 5 Terms and Concepts 581
10 OCP Exam 5 Terms and Concepts 581
Basic Net8 Architecture 582
Networking Overview 582
Basic Net8 Server-Side Configuration 584
Basic Net8 Client Side Configuration 585
Centralized Naming Concepts 586
Usage and Configuration of Oracle Names 586
Usage and Configuration of the Multithreaded Server 587
Troubleshoot the Network Environment 589
Security in the Network Environment 592
Fill-in-the-Blanks 594
Fill-in-the-Blank Answers 595
A Additional OCP Topical Questions 597
A Additional OCP Topical Questions 597
New Features Questions 598
Answers to New Features Questions 608
B Glossary of Common Oracle Terms 619
B Gloossary of Common Oracle Terms 619
Index 635
Index 635