《Oracle 8故障解决手册》求取 ⇩

1 OCP Exam 1:Introduction to SQL and PL/SQL3

1 OCP Exam 1:Introduction to SQLand PL/SQL3

PART I OCP Oracle8i DBA Practice Exams3

PART I OCP Oracle8i DBA Practice Exams3

OCP Exam 1 Topic Areas4

Practice Exam 19

FOREWORD17

ACKNOWLEDGMENTS19

INTRODUCTION21

Practice Exam 227

Practice Exam 350

Answers to Practice Exam 167

Answers to Practice Exam 280

Answers to Practice Exam 394

2 OCP Exam 2:Database Administration107

2 OCP Exam 2:Database Administration107

OCP Exam 2 Topic Areas108

Practice Exam 1113

Practice Exam 2130

Practice Exam 3146

Answers to Practice Exam 1163

Answers to Practice Exam 2177

Answers to Practice Exam 3191

3 OCP Exam 3:Backup and Recovery Workshop207

3 OCP Exam 3:Backup and Recovery Workshop207

OCP Exam 3 Topic Areas208

Practice Exam 1212

Practice Exam 2228

Practice Exam 3244

Answers to Practice Exam 1260

Answers to Practice Exam 2274

Answers to Practice Exam 3287

4 OCP Exam 4:Performance Tuning Workshop303

4 OCP Exam 4:Performance Tuning Workshop303

OCP Exam 4 Topic Areas304

Practice Exam 1308

Practice Exam 2324

Practice Exam 3340

Answers to Practice Exam 1356

Answers to Practice Exam 2371

Answers to Practice Exam 3385

5 OCP Exam 5:Network Administration401

5 OCP Exam 5:Network Administration401

OCP Exam 5 Topic Areas402

Practice Exam 1405

Practice Exam 2418

Practice Exam 3432

Answers to Practice Exam 1445

Answers to Practice Exam 2457

Answers to Practice Exam 3468

PART II OCP Key Terms and Concepts483

6 OCP Exam I Terms and Concepts483

6 OCP Exam 1 Terms and Concepts483

PART II OCP Key Terms and Concepts483

Overview of Relational Databases,SQL,and PL/SQL484

Writing Basic SQL Statements485

Restricting and Sorting Data486

Single-Row Functions486

Displaying Data from Multiple Tables487

Subqueries488

Aggregating Data Using Group Functions488

Multiple-Column Subqueries489

Producing Readable Output from SQL*Plus489

Manipulating Data490

Creating and Managing Tables490

Including Constraints491

Creating Views492

Other Database Objects494

Oracle Data Dictionary494

Controlling User Access496

Declaring Variables496

Write Executable Statements497

Interacting with the Oracle Server497

Writing Control Structures498

Working with Composite Datatypes498

Writing Explicit Cursors499

Advanced Explicit Cursor Concepts500

Handling Exceptions500

Fill-In-the-Blanks501

Fill-In-the-Blank Answers504

7 OCP Exam 2 Terms and Concepts507

7 OCP Exam 2 Terms and Concepts507

Oracle Architectural Components508

Getting Started with Oracle Server509

Managing an Oracle Instance510

Creating a Database512

Data Dictionary Views and Standard Packages514

Maintaining the Control File515

Maintaining Redo Log Files515

Managing Tablespaces and Datafiles516

Storage Structures and Relationships518

Managing Rollback Segments518

Managing Tables519

Managing Indexes521

Maintaining Data Integrity522

Loading Data522

Reorganizing Data524

Managing Password Security and Resources525

Managing Users526

Managing Privileges526

Managing Roles529

Using National Language Support530

Fill-in-the-Blanks531

Fill-in-the-Blank Answers533

8 OCP Exam 3 Terms and Concepts535

8 OCP Exam 3 Terms and Concepts535

Backup and Recovery Considerations536

Oracle Recovery Structures and Processes537

Oracle Backup and Recovery Configuration537

Physical Backups Without Oracle Recovery Manager538

Oracle Recovery Without Recovery Manager540

Incomplete Oracle Recovery with Archiving543

Oracle Export and Import Utilities544

Additional Oracle Recovery Issues545

Oracle Utilities for Troubleshooting546

Oracle Recovery Manager Overview548

Oracle Recovery Catalog Creation and Maintenance549

Backups Using RMAN550

Restoration and Recovery Using RMAN550

Oracle Standby Database552

Fill-in-the-Blanks554

Fill-in-the-Blank Answers555

9 OCP Exam 4 Terms and Concepts557

9 OCP Exam 4 Terms and Concepts557

Tuning Overview558

Oracle Alert and Trance Files558

Usage and Configuration of Connection Manager558

Utilities and Dynamic Performance Views559

Tuning the Shared Pool560

Tuning the Buffer Cache561

Tuning the Redo Log Buffer563

Database Configuration and I/O Issues563

Using Oracle Blocks Efficiently565

Optimize Sort Operations566

Rollback Segment Tuning567

SQL Issues and Tuning Considerations for Different Applications568

Monitoring and Detecting Lock Contention568

Managing a Mixed Workload573

Tuning with Oracle Expert575

Multithreaded Server Tuning Issues576

Fill-in-the-Blanks578

Fill-in-the-Blank Answers579

10 OCP Exam 5 Terms and Concepts581

10 OCP Exam 5 Terms and Concepts581

Basic Net8 Architecture582

Networking Overview582

Basic Net8 Server-Side Configuration584

Basic Net8 Client Side Configuration585

Centralized Naming Concepts586

Usage and Configuration of Oracle Names586

Usage and Configuration of the Multithreaded Server587

Troubleshoot the Network Environment589

Security in the Network Environment592

Fill-in-the-Blanks594

Fill-in-the-Blank Answers595

A Additional OCP Topical Questions597

A Additional OCP Topical Questions597

New Features Questions598

Answers to New Features Questions608

B Glossary of Common Oracle Terms619

B Gloossary of Common Oracle Terms619

Index635

Index635