Oracle 8故障解决手册PDF电子书下载

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