OCP Oracle 9i Datebase New Features For Administrators考试指南(英文版)(Exam1Z0-030) (2008 年度畅销榜NO.15798 )

\r\n

ACKNOWLEDGMENTS\r\nINTROOUCTION\r\nPART 1\r\nOracle9i New Features Exam Guide\r\n\r\n1 Security Enhancements\r\n\r\nPrivileged Connections\r\nDeprecation of CONN ECT INTERNAL\r\nDeprecation of Server Manager\r\nStringent Default Security with the Database Creation\r\nAssistant (DBCA)\r\nVirtual Private Database (VPD)\r\nPolicy Management Tool\r\nSecure Application Role\r\nGlobal Application Context\r\nMultiple Policies\r\nPartitioned Fine-Grained Access Control\r\nFine-Grained Auditing (FGA)\r\nAudit Column\r\nAudit Event Handler\r\nEnhancements to Encryption\r\nOptional Security Products\r\nOracle Label Security\r\nOracle Single Sign-On (SSO)\r\nOracle Enterprise Login Assistant\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill-in-the-Blanks\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n2 Availability Enhancements\r\n\r\nGeneral High-Availability Technology\r\nMinimal I/O Recovery\r\nFast-Start Time-Based Recovery Limit\r\nOracle Flashback\r\nResumable Space Allocation\r\nExport/Import Features\r\nData Cuard\r\nA Comprehensive Architectural Framework\r\nData Availability Modes\r\nDatabase Role Transitions\r\nArchive Log Gaps\r\nManaged Recovery Process (MRP)\r\nDelayed Redo Logs\r\nOnline Operations\r\nRebuilding Indexes Online\r\nUsing Index-Organized Tables (IOTs) Online\r\nRedefining Tables Online.\r\nValidating the Structure with the Online Analyze Command\r\nUsing the Server Parameter File (SPFILE)\r\nReplication Enhancements\r\nAdding New Masters Without Quiescing\r\nRow-Level System Change Numbers\r\nMaterialized View's Fast Refresh Capability\r\nObject Replication\r\nJob Queue Initialization Parameters\r\nLogMiner\r\nOOL Statement Support\r\nCapability to Use an Online Dictionary\r\nDDL Tracking in the Dictionary\r\nDictionary Staleness Detection\r\nCapability to Skip Log Corruptions\r\nLogMiner Viewer\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\n3 Manageability Enhancements\r\n\r\nDatabase Resource Manager\r\nAutomatically Detecting and Preempting Long-Running\r\nOperations\r\nAutomatically Limiting Resource Consumption\r\nSegment Management\r\nAutomatic Global Index Management\r\nExternal Tables\r\nList Partitions\r\nMetadata Application Programming Interface (API)\r\nAutomatic Segment Space Management\r\nBitmap join Indexes\r\nScalable Session Management\r\nThe Oracle Shared Server\r\nExternal Procedure Agents\r\nMultithreaded Heterogeneous Service (HS) Agents\r\nOCI Connection Pooling\r\nThe Core Oracle Kernel Library\r\nFile Management\r\nCreating and Managing OMFs\r\nAutomatically Deleting Non-OMF Files Using SQL\r\nDefault Temporary Tablespaces\r\nTablespace Management\r\nAutomatic Undo Management (AUM)\r\nCreating and Managing UNDO Tablespaces\r\nMultiple Block Sizes Within a Database\r\nDatabase Workspace Management\r\nThe Workspace Manager Concept\r\nCreating and Managing Workspaces\r\nThe Workspace Administrator Role\r\nExport and Import Considerations for Workspaces\r\nMemory Management\r\nAutomatic and Dynamic Sizing of SQL Working Areas\r\nViews and Columns for SQL Execution Memory Management\r\nAllocating and Tracking Memory for Dynamic SGA\r\nBackup and Recovery\r\nRecovery Manager (RMAN) Manageability and Reliability\r\nEnhancements\r\nTrial Recovery\r\nMiscellaneous RMAN Enhancements\r\nOracle Enterprise Manager (OEM)\r\nNew Console Look and Feel\r\nStandalone Mode for the Console\r\nIntegrated OEM Functionality\r\nHTML Reports\r\nUser Defined Events\r\nChapter Summary\r\nTwo-Minute Drill\r\nFill - in-the- B1anks\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n4 Performance and Scalability Enhancements\r\n\r\nPerformance Enhancements\r\nIndex Monitoring\r\nSkip Scan Index Access\r\nCursor Sharing\r\nCached Execution Plans\r\nFirst Rows Optimization\r\nGathering System Statistics\r\nReal Application Clusters (RACs)\r\nBenefits of Orac1e RACs\r\nRAC Architecture\r\nResource Modes and Resource Roles\r\nCache Fusion\r\nShared Server Side Initialization Parameter File\r\nChapter Summary\r\nTwo-Minute Orill\r\nFill - in-the-Blanks\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\n\r\n5 Language Enhancements\r\n\r\nEnhancements SQL\r\nISO/ANSI Standardization\r\nConstraints\r\nFOR UPDATE WAIT\r\nLOBs\r\nPL/SQL\r\nEnhancements to Globalization\r\nNew Date and Time Datatypes\r\nEnhancements to Unicode\r\nEnhancements to Sorting\r\nThe Character Set Scanner\r\nByte and Character Semantics\r\nThe Locale Builder\r\nChapter Summary\r\nTwo-Minute Dri1l\r\nFill-in-the-Blanks\r\nChapter Questions\r\nFill-in-the-Blank Answers\r\nAnswers to Chapter Questions\r\nPART II\r\nOracle9i Certified Professional New Features Practice Exams\r\n\r\n6 OCP Oracle9i Upgrade Exam: New Features for Administrators\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\nGlossary\r\n\r\nIndex