图书介绍

Oracle 8故障解决手册pdf电子书版本下载

（美）（R.V.韦尔普里）Rama Velpuri，（美）（A.A.阿德科利）Anand Adkoli著；何江华等译著
出版社：北京：机械工业出版社
ISBN：711106688X
出版时间：1998
标注页数：662页
文件大小：33MB
文件页数：688页
主题词：

PDF下载

点此进入-本书在线PDF格式电子书下载【推荐-云解压-方便快捷】直接下载PDF格式图书。移动端-PC端通用
种子下载[BT下载速度快] 温馨提示：（请使用BT下载软件FDM进行下载）软件下载地址页直链下载[便捷但速度慢] [在线试读本书] [在线获取解压码]

点击复制MD5值：4a5a6bea1be883f71e6fb16964269200

下载说明

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

下载的文件为RAR压缩包。需要使用解压软件进行解压得到PDF格式图书。

点击复制85GB完整离线版磁力链接到迅雷FDM等BT下载工具进行下载详情点击-查看共享计划

建议使用BT下载工具Free Download Manager进行下载,简称FDM(免费,没有广告,支持多平台）。本站资源全部打包为BT种子。所以需要使用专业的BT下载软件进行下载。如 BitComet qBittorrent uTorrent等BT下载工具。迅雷目前由于本站不是热门资源。不推荐使用！后期资源热门了。安装了迅雷也可以迅雷进行下载！

（文件页数要大于标注页数，上中下等多册电子书除外）

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

图书目录

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

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

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

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

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

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

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

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

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

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

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