This book is divided into two units, the first containing preparatory material for the Oracle9i DBA Fundamentals I exam, part of the Oracle's, Oracle9i DBA certification track. The first unit has six chapters, each containing several discussions that focus on a particular topic or subtopic objective listed by the Oracle Certified Professional Oracle9i DBA Track Candidate Guide for the DBA Fundamentals I exam. (For a complete listing of all the topics tested for this exam, see Chapter 1 .)These discussions are followed by a For Review section, each listing the three or four most important concepts for you to retain from the discussion. After the review, you'll see two to six exercise questions in exam-based multiple choice or short answer format. Following the questions you will find an answer key for those questions, which should help you master the material even more quickly. Thus,with this book you're never more than a few pages away from demonstrating what you've learned about Oracle9i DBA topics for the OCP exam.
Jason S. Couchman
Jason S. Couchman is a database consultant and the author of Oracle8i Certified Professional DBA Certilication Exam Guide also from Oracle Press. He is a regular presenter on Oracle and OCP at international Oracle user conferences and meetings. His work has been published by Oracle Magazine, Harvard Business School Publishing, and Gannett Newspapers, among others.
Sudheer N. Harisetti
Sudheer N. Marisetti is a database, Unix, and Web administrator and president of Abacus Concepts Inc., a New Jersey-based consulting firm specializing in designing, bui1ding, and maintaining database systems. He is an adjunct faculty member at Columbia University teaching advanced Oracle administration classes. He holds a master's degree in electrical engineering.
Jason's interest in Oracle certification began in 1996 when he read about the Oracle OBA certificate offered by the Chauncey Group. He found it difficult to prepare for that certification exam for two reasons.First, there was an absence of practice questions readily available.Second, preparation for the exam involved reviewing six or seven different manuals and Oracle Press books, none of which were particularly suited to the task. Judging from the response to the pro1iferation of titles now available in the Oracle Certified Professional (OCP) Exam Guide Series from Oracle Press, it would seem others have had similar experiences.
This book is divided into two units, the first containing preparatory material for the Oracle9i DBA Fundamentals I exam, part of the Oracle's, Oracle9i DBA certification track. The first unit has six chapters, each containing several discussions that focus on a particuIar topic or subtopic objective listed by the Oracle Certified Professional Oracle9i DBA Track Candidate Guide for the DBA Fundamentals I exam. (For a complete listing of all the topics tested for this exam, see Chapter 1 .)These discussions are followed by a For Review section, each listing the three or four most important concepts for you to retain from the discussion. After the review, you'll see two to six exercise questions in exam-based multiple choice or short answer format. Following the questions you will find an answer key for those questions, which should help you master the material even more quickly. Thus,with this book you're never more than a few pages away from demonstrating what you've learned about Oracle9i DBA topics for the OCP exam.
At the end of each chapter, you will find a short summary of what was coveredm in the chapter, followed by a Two-Minute Drill. The Two-Minute Drill contains another bulleted list of fast facts to revieW or crib notes for the days 1eading up to your OCP exam. The chapters conclude with 5 to 20 short answer and exam-based multiple choice questions designed to help you further test your understanding of the materials you learned in the chapter.
The second unit consists of one chapter containing three full-length practice exams. Each test contains exam-based multiple choice and scenario-based questions that are designed to help you strengthen your test-taking skills for the OCP exams. You will also find answers and in-depth explanations for every question in the practice exams in the back of that chapter, along with a reference back to the exam topic and subtopic objectives from the OCP Candidate Guide. This feature should help you determine your areas requiring further improvement with pinpoint accuracy
Finally, a note about updates and errata. Because OCP covers such vast ground in a short time, this has become a living text. If you feel you have encountered difficulties due to errors, you can check out www.OraclePressBooks.com to find the Latest errata.
Good luck!
(美)Jason S.Couchman ,Sudheer N.Marisetti:暂无简介
PART I
Preparing for OCP Database Administration
Fundamentals I Exam
I Basics of the Oracle Database Architecture
Oracle Archit6ctural Components
Oracle Server Architecture
Reading Data from Disk for Users: The Server Process
Structures That Connect Users to Oracle Servers
Stages in Processing Queries, Changes, and commits
Getting Started with the Oracle Server
Common Database Administrative Tools
The Oracle Universal Installer
Benefits of Optimal Flexible Architecture
Setting Up Password File Authentication
Using Orac1e Enterprise Manager Components
Managing an Oracle Instance
Creating and Managing Initialization Parameter File
Configuring Oracle-Managed Files (OMF)
Starting an Instance
Monitoring Use of Diagnostic Files
Creating an Orac1e Database
Prerequisites for Database Creation
Creating Databases Using Database Configuration Assistant
Creating a Database Manually
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
2 Managing the Physical Database Structure
Data Dictionary Content and Usage
Constructing the Data Dietionary Views
Key Data Dictionary Components and C
Querying the Data Dictionary
Maintaining Contro1 Fi1es
How Control Files Are Used
Examining Cootrol File Contents
Managing Contro1 Files with Oracle-Managed Fites
Obtaining Information about Control Files
Mu1tip1exing Control Files
Maintaining Redo Log Files
The Purpose and Structure of Online Redo Logs
Controlting Log Switches and Checkpoints
Multiplexing and Maintaining Redo Log Files
Managing On1ine Redo Log Files with OMF
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
3 ManagingTablespaces and Data files
Describing the Logica1 Structure of the Database
Creating Tablespaces
Changing Tablespace Size
Allocating Space for Temporary Segments
Temporary Segments in Permanent Tablespaces
Changing Tablespace Status
Changing Tablespace Storage Settings
Oracle-Managed Files (OMF)
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
4 Storage Structures and Undo Data
Storage Structures and Relationships
Different Segment Types and Their Uses
Controlling the Use of Extents by Segments
Using B1ock Space Utilization Parameters
Obtaining Information about Storage Structures
Managing Undo Data
The Purpose of Undo Segments
Implementing Automatic Undo Management
Creating and Configuring Undo Segments Manually
Obtaining Information about Undo Data
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
5 Managing Database Objects
ManagingTables,
Various Methods of Storing Data
Distinguishing Oracle Datatypes
Extended and Restricted ROWIDs
Structure of Data Blocks and Rows
Creating Permanent and Temporary Tables
Managing Storage Structures in a Table
Reorganizing, Truncating, and Dropping Tables
Dropping Unused Columns from Tables
Managing Indexes
Different Index Types and Their Uses
Creating B-Tree and Bitmap Indexes
Reorganizing Indexes
Dropping Indexes
Getting Index Information from the Data Dictionary
Monitoring Use of Indexes
Managing Data Integrity
Implementing Data Integrity Constraints
Maintaining Integrity Constraints
Obtaining Constraint Information from Oracle
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
6 Managing Database Users
Managing Users
Creating New Database Users
Altering and Dropping Existing Users
Monitoring Information about Existing Users
Managing Password Security and Resources
Controlling Resource Use with Profiles
Administering Profiles
Administering Passwords Using Profiles
Obtaining Profile Information from the Data Dictionary
Managing Privileges
Identifying System and Object Privileges
Granting and Revoking Privileges
Identifying Audit Capabilities
Managing Roles
Creating and Modifying Roles
Controlling Availability of Roles
Removing Roles
Using Predefined Roles
Displaying Role Information from the Data Dictionary
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
PART 2
OCP Oracle9i DBA Fundamentals I Practice Exams
7 OCP Database Administration Fundamentals I
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Practice Exam 3
A Globalization Support
Choosing a Database and a National Character Set for a Database
Specifying Language-Dependent Behavior
NLS Parameters
Obtaining Information about Globalization Support Usage
Index