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