Ships from: Palm Bay, FL
Usually ships in 1-2 business days
Ships from: Boonsboro, MD
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Get Certified with Official Exam Prep Material from Oracle Press
| Preface | xv | |
| Acknowledgments | xvii | |
| Introduction | xix | |
| Part 1 | Preparing for OCP Database Administration Fundamentals I Exam | |
| 1 | Basics of the Oracle Database Architecture | 5 |
| Oracle Architectural Components | 6 | |
| Oracle Server Architecture | 7 | |
| Reading Data from Disk for Users: The Server Process | 9 | |
| Structures That Connect Users to Oracle Servers | 12 | |
| Stages in Processing Queries, Changes, and commits | 15 | |
| Getting Started with the Oracle Server | 22 | |
| Common Database Administrative Tools | 22 | |
| The Oracle Universal Installer | 24 | |
| Benefits of Optimal Flexible Architecture | 29 | |
| Setting Up Password File Authentication | 31 | |
| Using Oracle Enterprise Manager Components | 38 | |
| Managing an Oracle Instance | 44 | |
| Creating and Managing Initialization Parameter File | 45 | |
| Configuring Oracle-Managed Files (OMF) | 51 | |
| Starting an Instance | 54 | |
| Monitoring Use of Diagnostic Files | 62 | |
| Creating an Oracle Database | 66 | |
| Prerequisites for Database Creation | 66 | |
| Creating Databases Using Database Configuration Assistant | 72 | |
| Creating a Database Manually | 75 | |
| Chapter Summary | 79 | |
| Two-Minute Drill | 80 | |
| Fill-in-the-Blank Questions | 85 | |
| Chapter Questions | 85 | |
| Fill-in-the-Blank Answers | 89 | |
| Answers to Chapter Questions | 89 | |
| 2 | Managing the Physical Database Structure | 93 |
| Data Dictionary Content and Usage | 94 | |
| Constructing the Data Dictionary Views | 95 | |
| Key Data Dictionary Components and Contents | 98 | |
| Querying the Data Dictionary | 105 | |
| Maintaining Control Files | 109 | |
| How Control Files Are Used | 109 | |
| Examining Control File Contents | 112 | |
| Managing Control Files with Oracle-Managed Files | 116 | |
| Obtaining Information about Control Files | 119 | |
| Multiplexing Control Files | 123 | |
| Maintaining Redo Log Files | 125 | |
| The Purpose and Structure of Online Redo Logs | 125 | |
| Controlling Log Switches and Checkpoints | 129 | |
| Multiplexing and Maintaining Redo Log Files | 132 | |
| Managing Online Redo Log Files with OMF | 135 | |
| Chapter Summary | 137 | |
| Two-Minute Drill | 137 | |
| Chapter Questions | 142 | |
| Answers to Chapter Questions | 144 | |
| 3 | Managing Tablespaces and Datafiles | 147 |
| Describing the Logical Structure of the Database | 148 | |
| Creating Tablespaces | 155 | |
| Changing Tablespace Size | 161 | |
| Allocating Space for Temporary Segments | 164 | |
| Temporary Segments in Permanent Tablespaces | 164 | |
| Changing Tablespace Status | 169 | |
| Changing Tablespace Storage Settings | 172 | |
| Oracle-Managed Files (OMF) | 176 | |
| Chapter Summary | 179 | |
| Two-Minute Drill | 179 | |
| Fill-in-the-Blank Questions | 182 | |
| Chapter Questions | 182 | |
| Fill-in-the-Blank Answers | 184 | |
| Answers to Chapter Questions | 184 | |
| 4 | Storage Structures and Undo Data | 187 |
| Storage Structures and Relationships | 188 | |
| Different Segment Types and Their Uses | 189 | |
| Controlling the Use of Extents by Segments | 197 | |
| Using Block Space Utilization Parameters | 206 | |
| Obtaining Information about Storage Structures | 210 | |
| Managing Undo Data | 213 | |
| The Purpose of Undo Segments | 213 | |
| Implementing Automatic Undo Management | 217 | |
| Creating and Configuring Undo Segments Manually | 222 | |
| Obtaining Information about Undo Data | 232 | |
| Chapter Summary | 233 | |
| Two-Minute Drill | 233 | |
| Fill-in-the-Blank Questions | 236 | |
| Chapter Questions | 236 | |
| Fill-in-the-Blank Answers | 239 | |
| Answers to Chapter Questions | 239 | |
| 5 | Managing Database Objects | 241 |
| Managing Tables | 242 | |
| Various Methods of Storing Data | 243 | |
| Distinguishing Oracle Datatypes | 248 | |
| Extended and Restricted ROWIDs | 252 | |
| Structure of Data Blocks and Rows | 255 | |
| Creating Permanent and Temporary Tables | 257 | |
| Managing Storage Structures in a Table | 264 | |
| Reorganizing, Truncating, and Dropping Tables | 268 | |
| Dropping Unused Columns from Tables | 274 | |
| Managing Indexes | 277 | |
| Different Index Types and Their Uses | 278 | |
| Creating B-Tree and Bitmap Indexes | 285 | |
| Reorganizing Indexes | 289 | |
| Dropping Indexes | 294 | |
| Getting Index Information from the Data Dictionary | 295 | |
| Monitoring Use of Indexes | 297 | |
| Managing Data Integrity | 301 | |
| Implementing Data Integrity Constraints | 301 | |
| Maintaining Integrity Constraints | 308 | |
| Obtaining Constraint Information from Oracle | 312 | |
| Chapter Summary | 314 | |
| Two-Minute Drill | 315 | |
| Fill-in-the-Blank Questions | 318 | |
| Chapter Questions | 318 | |
| Fill-in-the-Blank Answers | 323 | |
| Answers to Chapter Questions | 323 | |
| 6 | Managing Database Users | 327 |
| Managing Users | 328 | |
| Creating New Database Users | 328 | |
| Altering and Dropping Existing Users | 334 | |
| Monitoring Information about Existing Users | 339 | |
| Managing Password Security and Resources | 341 | |
| Controlling Resource Use with Profiles | 342 | |
| Administering Profiles | 346 | |
| Administering Passwords Using Profiles | 350 | |
| Obtaining Profile Information from the Data Dictionary | 355 | |
| Managing Privileges | 357 | |
| Identifying System and Object Privileges | 358 | |
| Granting and Revoking Privileges | 364 | |
| Identifying Audit Capabilities | 369 | |
| Managing Roles | 377 | |
| Creating and Modifying Roles | 377 | |
| Controlling Availability of Roles | 380 | |
| Removing Roles | 384 | |
| Using Predefined Roles | 385 | |
| Displaying Role Information from the Data Dictionary | 387 | |
| Chapter Summary | 388 | |
| Two-Minute Drill | 389 | |
| Fill-in-the-Blank Questions | 395 | |
| Chapter Questions | 395 | |
| Fill-in-the-Blank Answers | 399 | |
| Answers to Chapter Questions | 399 | |
| Part 2 | OCP Oracle9i DBA Fundamentals I Practice Exams | |
| 7 | OCP Database Administration Fundamentals I | 405 |
| Practice Exam 1 | 406 | |
| Practice Exam 2 | 424 | |
| Practice Exam 3 | 440 | |
| Answers to Practice Exam 1 | 460 | |
| Answers to Practice Exam 2 | 473 | |
| Answers to Practice Exam 3 | 487 | |
| A | Globalization Support | 503 |
| Choosing a Database and a National Character Set for a Database | 505 | |
| Specifying Language-Dependent Behavior | 506 | |
| NLS Parameters | 507 | |
| Obtaining Information about Globalization Support Usage | 508 | |
| Index | 511 |
Overview
Get Certified with Official Exam Prep Material from Oracle Press
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 ...