"Oracle."

"Oracle Press."

Preparing for OCP Database Administration Fundamentals I Exam -- Basics of the Oracle Database Architecture -- Oracle Architectural 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 Oracle 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 Oracle Database -- Prerequisites for Database Creation -- Creating Databases Using Database Configuration Assistant -- Creating a Database Manually -- Managing the Physical Database Structure -- Data Dictionary Content and Usage -- Constructing the Data Dictionary Views -- Key Data Dictionary Components and Contents -- Querying the Data Dictionary -- Maintaining Control Files -- How Control Files Are Used -- Examining Control File Contents -- Managing Control Files with Oracle-Managed Files -- Obtaining Information about Control Files -- Multiplexing Control Files -- Maintaining Redo Log Files -- The Purpose and Structure of Online Redo Logs -- Controlling Log Switches and Checkpoints -- Multiplexing and Maintaining Redo Log Files -- Managing Online Redo Log Files with OMF -- Managing Tablespaces and Datafiles -- Describing the Logical 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) -- Storage Structures and Undo Data -- Storage Structures and Relationships -- Different Segment Types and Their Uses -- Controlling the Use of Extents by Segments -- Using Block 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 -- Managing Database Objects -- Managing Tables -- 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 -- 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 -- OCP Oracle9i DBA Fundamentals I Practice Exams -- OCP Database Administration Fundamentals I -- Globalization Support -- Choosing a Database and a National Character Set for a Database -- Specifying Language-Dependent Behavior -- NLS Parameters.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam -- a required exam for Oracle9i DBA certification -- using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals I exam.