| |
| |
| Preface | |
| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| 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 | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Fill-in-the-Blank Questions | |
| |
| |
| Chapter Questions | |
| |
| |
| Fill-in-the-Blank Answers | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| 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 | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| 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) | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Fill-in-the-Blank Questions | |
| |
| |
| Chapter Questions | |
| |
| |
| Fill-in-the-Blank Answers | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| 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 | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Fill-in-the-Blank Questions | |
| |
| |
| Chapter Questions | |
| |
| |
| Fill-in-the-Blank Answers | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| 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 | |
| |
| |
| Chapter Summary | |
| |
| |
| Two-Minute Drill | |
| |
| |
| Fill-in-the-Blank Questions | |
| |
| |
| Chapter Questions | |
| |
| |
| Fill-in-the-Blank Answers | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| 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 | |
| |
| |
| |
| OCP Oracle9i DBA Fundamentals I Practice Exams | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |