OCP　Oracle　8i　DBA考试模拟试题与解答（英文版） (2010 年度畅销榜NO.40321 )

PART 1\r\n\r\nOCP Oracle8i DBA Practice Exams\r\n1 OCP Exam 1: Introduction to SQL and PL/SQL\r\n\r\nOCP Exam 1 Topic Areas\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 Pract1ce Exam 3\r\n\r\n2 OCP Exam 2: Database Administration\r\n\r\nOCP Exam 2 Topic Areas\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\n3 OCP Exam 3: Backup and Recovery Workshop\r\n\r\nOCP Exam 3 Topic Areas\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\n4 OCP Exam 4: Performance Tuning Workshop\r\n\r\nOCP Exam 4 Topic Areas\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\n5 OCP Exam 5: Network Administration\r\n\r\nOCP Exam 5 Topic Areas\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\nPART II\r\nOCP Key Terms and Concepts\r\n\r\n6 OCP Exam I Terms and Concepts\r\n\r\nOverview of Relational Databases, SQL, and PL/SQL\r\nWriting Basic SQL Statements\r\nRestricting and Sorting Data\r\nSingle-Row Functions\r\nDisplaying Data from Multiple Tables\r\nAggregating Data Using Group Functions\r\nSubqueries\r\nMultiple-Column Subqueries\r\nProducing Readable Output from SQL*Plus\r\nManipulating Data\r\nCreating and Managing Tables\r\nIncluding Constraints\r\nCreating Views\r\nOracle Data Dictionary\r\nOther Database Objects\r\nControlling User Access\r\nDeclaring Variables\r\nWrite Executable Statements\r\nInteracting with the OracIe Server\r\nWriting Control Structures\r\nWorking with Composite Datatypes\r\nWriting Explicit Cursors\r\nAdvanced Explicit Cursor Concepts\r\nHandling Exceptions\r\nFill-In-the-Blanks\r\nFill-In-the-Blank Answers\r\n\r\n7 OCP Exam 2 Terms and Concepts\r\n\r\nOracle Architectural Components\r\nGetting Started with Oracle Server\r\nManaging an Oracle Instance\r\nCreating a Database\r\nData Dictionary Views and Standard Packages\r\nMaintaining the Control FiIe\r\nMaintaining Redo Log Files\r\nManaging Tablespaces and Datafiles\r\nStorage Structures and Relationships\r\nManaging Rollback Segments\r\nManaging Tables\r\nManaging Indexes\r\nMaintaining Data Integrity\r\nLoading Data\r\nReorganizing Data\r\nManaging Password Security and Resources\r\nManaging Users\r\nManaging Privileges\r\nManaging Roles\r\nUsing National Language Support\r\nFill-in-the-Blanks\r\nFill-in-the-Blank Answers\r\n\r\n8 OCP Exam 3 Terms and Concepts\r\n\r\nBackup and Recovery Considerations\r\nOracle Recovery Structures and Processes\r\nOracle Backup and Recovery Configuration\r\nPhysical Backups Without Oracle Recovery Manager\r\nOracle Recovery Without Recovery Manager\r\nIncomplete Oracle Recovery with Archiving\r\nOracle Export and Import Utilities\r\nAdditional Oracle Recovery Issues\r\nOracle Utilities for Troubleshooting\r\nOracIe Recovery Manager Overview\r\nOracle Recovery Catalog Creation and Maintenance\r\nBackups Using RMAN\r\nRestoration and Recovery Using RMAN\r\nOracle Standby Database\r\nFiIl-in-the-Blanks\r\nFill-in-the-Blank Answers\r\n\r\n9 OCP Exam 4 Terms and Concepts\r\n\r\nTuning Overview\r\nOracle Alert and Trace Files\r\nUtilities and Dynamic Performance Views\r\nTuning the Shared Pool\r\nTuning the Buffer Cache\r\nTuning the Redo Log Buffer\r\nDatabase Configuration and I/O Issues\r\nUsing Oracle Blocks Efficiently\r\nOptimize Sort Operations\r\nRollback Segment Tuning\r\nMonitoring and Detecting Lock Contention\r\nSQL Issues and Tuning Considerations for Different Applications\r\nManaging a Mixed Workload\r\nTuning with Oracle Expert\r\nMultithreaded Server Tuning Issues\r\nFill-in-the-Blanks\r\nFill-in-the-Blank Answers\r\n\r\n10 OCP Exam 5 Terms and Concepts\r\n\r\nNetworking Overview\r\nBasic Net8 Architecture\r\nBasic Net8 Server-Side Configuration\r\nBasic Net8 Client Side Configuration\r\nCentralized Naming Concepts\r\nUsage and Configuration of Oracle Names\r\nUsage and Configuration of the Multithreaded Server\r\nUsage and Configuration of Connection Manager\r\nTroubleshoot the Network Environment\r\nSecurity in the Network Environment\r\nFill-in-the-Blanks\r\nFill-in-the-Blank Answers\r\n\r\nA Additional OCP Topical Questions\r\n\r\nNew Features Questions\r\nAnswers to New Features Questions\r\n\r\nB Glossary of Common Oracle Terms\r\n\r\nIndex