Oracle8i DBA考试模拟试题与解答

内容简介

　　This book is divided into two units， the first containing practice exams for each test in the Oracle8i DBA certification track from OracIe. The first unit has five chapters，one for each exam. Each chapter begins with a listing of all the topics tested by theexam， as defined by the Oracle Candidate Guide， a free publication available from Oracle University. Each chapter also contains three practice tests that are approximately the same length of the actual test you will face on exam day. At the end of each chapter，you will find answers with explanations for each of the questions in the exam， along with a reference back to the topic/subtopic listing the question is meant to address.

作者简介

暂缺《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