Oracle8i DBA考试模拟试题与解答

PART 1

OCP Oracle8i DBA Practice Exams

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

OCP Exam 1 Topic Areas

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Pract1ce Exam 3

2 OCP Exam 2: Database Administration

OCP Exam 2 Topic Areas

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Practice Exam 3

3 OCP Exam 3: Backup and Recovery Workshop

OCP Exam 3 Topic Areas

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Practice Exam 3

4 OCP Exam 4: Performance Tuning Workshop

OCP Exam 4 Topic Areas

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Practice Exam 3

5 OCP Exam 5: Network Administration

OCP Exam 5 Topic Areas

Practice Exam 1

Practice Exam 2

Practice Exam 3

Answers to Practice Exam 1

Answers to Practice Exam 2

Answers to Practice Exam 3

PART II

OCP Key Terms and Concepts

6 OCP Exam I Terms and Concepts

Overview of Relational Databases, SQL, and PL/SQL

Writing Basic SQL Statements

Restricting and Sorting Data

Single-Row Functions

Displaying Data from Multiple Tables

Aggregating Data Using Group Functions

Subqueries

Multiple-Column Subqueries

Producing Readable Output from SQL*Plus

Manipulating Data

Creating and Managing Tables

Including Constraints

Creating Views

Oracle Data Dictionary

Other Database Objects

Controlling User Access

Declaring Variables

Write Executable Statements

Interacting with the OracIe Server

Writing Control Structures

Working with Composite Datatypes

Writing Explicit Cursors

Advanced Explicit Cursor Concepts

Handling Exceptions

Fill-In-the-Blanks

Fill-In-the-Blank Answers

7 OCP Exam 2 Terms and Concepts

Oracle Architectural Components

Getting Started with Oracle Server

Managing an Oracle Instance

Creating a Database

Data Dictionary Views and Standard Packages

Maintaining the Control FiIe

Maintaining Redo Log Files

Managing Tablespaces and Datafiles

Storage Structures and Relationships

Managing Rollback Segments

Managing Tables

Managing Indexes

Maintaining Data Integrity

Loading Data

Reorganizing Data

Managing Password Security and Resources

Managing Users

Managing Privileges

Managing Roles

Using National Language Support

Fill-in-the-Blanks

Fill-in-the-Blank Answers

8 OCP Exam 3 Terms and Concepts

Backup and Recovery Considerations

Oracle Recovery Structures and Processes

Oracle Backup and Recovery Configuration

Physical Backups Without Oracle Recovery Manager

Oracle Recovery Without Recovery Manager

Incomplete Oracle Recovery with Archiving

Oracle Export and Import Utilities

Additional Oracle Recovery Issues

Oracle Utilities for Troubleshooting

OracIe Recovery Manager Overview

Oracle Recovery Catalog Creation and Maintenance

Backups Using RMAN

Restoration and Recovery Using RMAN

Oracle Standby Database

FiIl-in-the-Blanks

Fill-in-the-Blank Answers

9 OCP Exam 4 Terms and Concepts

Tuning Overview

Oracle Alert and Trace Files

Utilities and Dynamic Performance Views

Tuning the Shared Pool

Tuning the Buffer Cache

Tuning the Redo Log Buffer

Database Configuration and I/O Issues

Using Oracle Blocks Efficiently

Optimize Sort Operations

Rollback Segment Tuning

Monitoring and Detecting Lock Contention

SQL Issues and Tuning Considerations for Different Applications

Managing a Mixed Workload

Tuning with Oracle Expert

Multithreaded Server Tuning Issues

Fill-in-the-Blanks

Fill-in-the-Blank Answers

10 OCP Exam 5 Terms and Concepts

Networking Overview

Basic Net8 Architecture

Basic Net8 Server-Side Configuration

Basic Net8 Client Side Configuration

Centralized Naming Concepts

Usage and Configuration of Oracle Names

Usage and Configuration of the Multithreaded Server

Usage and Configuration of Connection Manager

Troubleshoot the Network Environment

Security in the Network Environment

Fill-in-the-Blanks

Fill-in-the-Blank Answers

A Additional OCP Topical Questions

New Features Questions

Answers to New Features Questions

B Glossary of Common Oracle Terms

Index