OCP Oracle9i Database-Fundamentals I考试指南（英文版） (2008 年度畅销榜NO.7804 )

'The OCP certification core track for DBAS consists of four tests in the following areas of Oracle9i: SQL, DBA Fundamentals I and II, and tuning, with the current content of those exams covering Oracle through Oracle9i. As of this printing, each test consists of about 60 multiple choice questions pertaining to the recommended usage of Oracle databases. You have about 90 minutes to take each exam. Obtaining certification for Oracle9i through the core track is contingent on taking and passing all core examinations. This book will help you prepare for the first exam in the DBA track. '\r\n

PREFACE\r\nACKNOWLEDGMENTS\r\nINTRODUCTION\r\n\r\nPART I Preparing for OCP Database Administration Fundamentals I Exam\r\n\r\n1 Basics of the Oracle Database Architecture\r\n\r\nOracle Architectural Components\r\nReading Data form Disk for Users:The Server Process\r\nStructures That Connect Users to Oracle Servers\r\nStages in Processing Queries,Changes,and commits\r\nGetting Started with the Oracle Server\r\nCommon Database Administrative Tools\r\nThe Oracle Universal Installer\r\nBenefits of Optimal Flexible Architecture\r\nSetting Up Password File Authentication\r\nUsing Oracle Enterprise Manager Components\r\nManaging an Oracle Instance\r\nCreating and Managing Initialization Parameter File\r\nConfiguring Oracle-Managed Files(OMF)\r\nStarting an Instance\r\nMonitoring Use of Diagnostic Files\r\nCreating an Oracle Database\r\nPrerequisites for Database Creation\r\nCreating Databases Using Database Configuration Assistant\r\nCreating a Database Manually\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n2 Managing the Physical Database Structure\r\n\r\nData Dicitonary Content and Usage\r\nConstructing the Data Dictionary Views\r\nKey Data Kictiionary Components and Contents\r\nQuerying the Data Dictionary\r\nMaintaining Control Files\r\nHow Control Files Are Used\r\nExamining Control File Contents\r\nManaging Control Files with Oracle-Managed Files\r\nObtaining Information about Control Files\r\nMultiplexing Control Files\r\nMaintaining Redo Log Files\r\nThe Purpose and Structure of Online Redo Logs\r\nControlling Log Switches and Checkpoints\r\nMultiplexing and Maintaining Redo Log Files\r\nManaging Online Redo Log Files with OMF\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n3 Managing Tablespaces and Datafiles\r\n\r\nDescribing the Logical Structure of the Database\r\nCreating Tablespaces\r\nChanging Tablespace Size\r\nAllocating Space for Temporary Segments\r\nTemporary Segments in Permanent Tablespaces\r\nChanging Tablespace Status\r\nChanging Tablespace Storage Settings\r\nOracle-Managed Files(OMF)\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n4 Storage structures and Undo Data\r\n\r\nStorage Structures and Relationships\r\nDifferent Segment Types and Their Uses\r\nControlling the Use of Extents by Segments\r\nUsing Block Space Utilization Parameters\r\nObtaining Information about Storage Structures\r\nManaging Undo Data\r\nThe Purpose of Undo Segments\r\nImplementing Automatic Undo Management\r\nCreating and Configuring Undo Segments Manually\r\nObtaining Information about Undo Data\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n5 Managing Database Objects\r\n\r\nManaging Tables\r\nVarious Methods of Storing Data\r\nDistinguishing Oracle Datatypes\r\nExtended and Restricted ROWIDs\r\nStructure of Data Blocks and Rows\r\nCreating Permanent and Temporary Tables\r\nManaging Storage Structures in a Table\r\nReorganizing,Truncating,and Dropping Tables\r\nDropping Unused Columns form Tables\r\nManaging Indexes\r\nDifferent Index Types and Their Uses\r\nCreating B-Tree and Bitmap Indexes\r\nReorganizing Indexes\r\nDropping Indexes\r\nGetting Index Information from the Data Dictionary\r\nMonitoring Use of Indexes\r\nManaging Data Integrity\r\nImplementing Data Integrity Constraints\r\nMaintaining Integrity Constraints\r\nObtaining Constraint Information from Oracle\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n6 Managing Database Users\r\n\r\nManaging Users\r\nCreating New Database Users\r\nAltering and Dropping Existing Users\r\nMonitoring Information about Existing Users\r\nManaging Password Security and Resources\r\nControlling Resource Use with Profiles\r\nAdministering Profiles\r\nAdministering Passwords Using Profiles\r\nObtaining Profile Information form the Data Dictionary\r\nManaging Privileges\r\nIdentifying System and Object Privileges\r\nGranting and Revoking Privileges\r\nIdentifying Audit Capabilities\r\nManaging Roles\r\nCreating and Modifying Roles\r\nControlling Availability of Roles\r\nRemoving Roles\r\nusing Predefined Roles\r\nDisplaying Role Informaiton from the Data Dictionary\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blank Questions\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\nPART II OCP Oracle9i DBA Fundamentals I Practice Exams\r\n\r\n7 OCP Database Administration Fundamentals I\r\n\r\nPractice Exam 1\r\nPractice Exam 2\r\nPractice Exam 3\r\nAnswers to Practice Exam 1\r\nAnswers to Practice Exam 2\r\nAnswers to Practice Exam 3\r\n\r\nA globalization Support\r\n\r\nChoosing a Database and a National Character Set for a Database\r\nSpecifying Language-Dependent Behavior\r\nNLS Parameters\r\nObtaining Information about Globalization Support Usage\r\n\r\nIndex