OCP Oracle9i Database: Fundamentals I Exam Guide
Search in google:
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 Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals I exam.100% complete coverage of all official exam objectives Exercises at the end of all discussions that reinforce your Oracle knowledge right away Tips, examples, and reviews in every chapter to help you remember key concepts Two-minute drills—quick and concise checklists that summarize each chapter's main points Chapter self-tests—exam-based questions complete with in-depth explanations More than 300 practice questions—including scenario-based questions Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.
PrefacexvAcknowledgmentsxviiIntroductionxixPart 1Preparing for OCP Database Administration Fundamentals I Exam1Basics of the Oracle Database Architecture5Oracle Architectural Components6Oracle Server Architecture7Reading Data from Disk for Users: The Server Process9Structures That Connect Users to Oracle Servers12Stages in Processing Queries, Changes, and commits15Getting Started with the Oracle Server22Common Database Administrative Tools22The Oracle Universal Installer24Benefits of Optimal Flexible Architecture29Setting Up Password File Authentication31Using Oracle Enterprise Manager Components38Managing an Oracle Instance44Creating and Managing Initialization Parameter File45Configuring Oracle-Managed Files (OMF)51Starting an Instance54Monitoring Use of Diagnostic Files62Creating an Oracle Database66Prerequisites for Database Creation66Creating Databases Using Database Configuration Assistant72Creating a Database Manually75Chapter Summary79Two-Minute Drill80Fill-in-the-Blank Questions85Chapter Questions85Fill-in-the-Blank Answers89Answers to Chapter Questions892Managing the Physical Database Structure93Data Dictionary Content and Usage94Constructing the Data Dictionary Views95Key Data Dictionary Components and Contents98Querying the Data Dictionary105Maintaining Control Files109How Control Files Are Used109Examining Control File Contents112Managing Control Files with Oracle-Managed Files116Obtaining Information about Control Files119Multiplexing Control Files123Maintaining Redo Log Files125The Purpose and Structure of Online Redo Logs125Controlling Log Switches and Checkpoints129Multiplexing and Maintaining Redo Log Files132Managing Online Redo Log Files with OMF135Chapter Summary137Two-Minute Drill137Chapter Questions142Answers to Chapter Questions1443Managing Tablespaces and Datafiles147Describing the Logical Structure of the Database148Creating Tablespaces155Changing Tablespace Size161Allocating Space for Temporary Segments164Temporary Segments in Permanent Tablespaces164Changing Tablespace Status169Changing Tablespace Storage Settings172Oracle-Managed Files (OMF)176Chapter Summary179Two-Minute Drill179Fill-in-the-Blank Questions182Chapter Questions182Fill-in-the-Blank Answers184Answers to Chapter Questions1844Storage Structures and Undo Data187Storage Structures and Relationships188Different Segment Types and Their Uses189Controlling the Use of Extents by Segments197Using Block Space Utilization Parameters206Obtaining Information about Storage Structures210Managing Undo Data213The Purpose of Undo Segments213Implementing Automatic Undo Management217Creating and Configuring Undo Segments Manually222Obtaining Information about Undo Data232Chapter Summary233Two-Minute Drill233Fill-in-the-Blank Questions236Chapter Questions236Fill-in-the-Blank Answers239Answers to Chapter Questions2395Managing Database Objects241Managing Tables242Various Methods of Storing Data243Distinguishing Oracle Datatypes248Extended and Restricted ROWIDs252Structure of Data Blocks and Rows255Creating Permanent and Temporary Tables257Managing Storage Structures in a Table264Reorganizing, Truncating, and Dropping Tables268Dropping Unused Columns from Tables274Managing Indexes277Different Index Types and Their Uses278Creating B-Tree and Bitmap Indexes285Reorganizing Indexes289Dropping Indexes294Getting Index Information from the Data Dictionary295Monitoring Use of Indexes297Managing Data Integrity301Implementing Data Integrity Constraints301Maintaining Integrity Constraints308Obtaining Constraint Information from Oracle312Chapter Summary314Two-Minute Drill315Fill-in-the-Blank Questions318Chapter Questions318Fill-in-the-Blank Answers323Answers to Chapter Questions3236Managing Database Users327Managing Users328Creating New Database Users328Altering and Dropping Existing Users334Monitoring Information about Existing Users339Managing Password Security and Resources341Controlling Resource Use with Profiles342Administering Profiles346Administering Passwords Using Profiles350Obtaining Profile Information from the Data Dictionary355Managing Privileges357Identifying System and Object Privileges358Granting and Revoking Privileges364Identifying Audit Capabilities369Managing Roles377Creating and Modifying Roles377Controlling Availability of Roles380Removing Roles384Using Predefined Roles385Displaying Role Information from the Data Dictionary387Chapter Summary388Two-Minute Drill389Fill-in-the-Blank Questions395Chapter Questions395Fill-in-the-Blank Answers399Answers to Chapter Questions399Part 2OCP Oracle9i DBA Fundamentals I Practice Exams7OCP Database Administration Fundamentals I405Practice Exam 1406Practice Exam 2424Practice Exam 3440Answers to Practice Exam 1460Answers to Practice Exam 2473Answers to Practice Exam 3487AGlobalization Support503Choosing a Database and a National Character Set for a Database505Specifying Language-Dependent Behavior506NLS Parameters507Obtaining Information about Globalization Support Usage508Index511
