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
鄂公網(wǎng)安備 42010302001612號 