Oracle 10g OCM exam topics
Server Configuration
[ ] Create the database
[ ] Determine and set sizing parameters for database structures
[ ] Create and manage temporary, permanent, and undo tablespaces
[ ] Stripe data files across multiple physical devices and locations
[ ] Configure the database environment to support optimal data access performance
[ ] Create and manage database configuration files
[ ] Create and manage bigfile tablespaces
[ ] Create and manage multiple network configuration files
[ ] Create and configure a listener
[ ] Configure the database instance to support shared server connections [ ] Set up network tracing
[ ] Manage Oracle network processes (the Listener Control utility)
[ ] Configure the network environment to allow connections to multiple databases
[ ] Use configurationless connections
Enterprise Manager Grid Control
[ ] Install the Enterprise Manager Grid Control software
[ ] Configure the Enterprise Manager repository
[ ] Create Enterprise Manager Grid Control users
[ ] Use Enterprise Manager to modify a database configuration
[ ] Configure Enterprise Manager to modify a database availability
[ ] Create and manage jobs
[ ] Create and monitor alerts
[ ] Create notifications
[ ] Implement Grid Control and Database Control
[ ] Choose the appropriate tablespace type for the intended use
[ ] Create Scheduler jobs
[ ] Create schedules
[ ] Assign jobs to windows
[ ] Create programs
[ ] Create job classes
[ ] Install the Enterprise Manager Grid Control infrastructure
[ ] Deploy Enterprise Manager Grid Control agents
[ ] Configure Grid Control for business requirements
Managing Database Availability
[ ] Create a recovery catalog database
[ ] Configure Recovery Manager
[ ] Use Recovery Manager to perform database backups
[ ] Use Recover Manager to perform complete database restore and recovery operations
[ ] Set Flashback Database parameters
[ ] Monitor Flashback Database logs and statistics
[ ] Perform a Flashback Database operation
[ ] Configure a flash recovery area
Data Management
[ ] Implement fine-grained auditing
[ ] Create a secure application role
[ ] Grant specific privileges for a Flashback Query
[ ] Set parameters for retaining undo
[ ] Implement fine-grained access control
[ ] Create and manage contexts
[ ] Use SQL*Loader
[ ] Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files)
[ ] Choose the appropriate partition method (range, hash, list, and composite)
[ ] Choose the appropriate partition key
[ ] Choose appropriate indexing methods (local, global, prefixed, and nonprefixed)
[ ] Perform partition maintenance operations
[ ] Maintain indexes on a partitioned table
[ ] Create and manage LOB segments
[ ] Apply parallelism appropriately
[ ] Tune memory for parallel operations
[ ] Set parallel parameters
Data Warehouse Management
[ ] Create external tables (Data Loader and Data Pump drivers)
[ ] Implement Data Pump export and import jobs for data transfer
[ ] Implement Data Pump to and from remote databases
[ ] Implement Replication/Streams
[ ] Configure and manage master replication
[ ] Configure and manage distributed materialized views
[ ] Configure and manage Streams for replication
Performance Management
[ ] Install Statspack
[ ] Adjust the default interval for statistics collection
[ ] Customize the events that are monitored
[ ] Use ADDM to analyze statistics and to identify performance bottlenecks and fix them
[ ] Implement automatic shared memory management
[ ] Tune memory using manual memory management
[ ] Monitor and tune SGA areas that are not automatically tuned
[ ] Implement automatic SQL execution memory management
[ ] Tune the PGA using work area size parameters
[ ] Use the PGA Advisor
[ ] Create a Database Resource Manager plan with directives (active session count, max execution time)
[ ] Create consumer groups
[ ] Configure consumer group mappings
[ ] Manage Services
[ ] Create and manage objects to accommodate different data access methods (schema tuning)
[ ] Use the SQL Tuning Advisor
[ ] Use the SQL Access Advisor
[ ] Gather Optimizer statistics
[ ] Interpret execution plan
[ ] Use SQL tuning tools and features
Real Application Clusters
[ ] Install Oracle Clusterware
[ ] Install the Oracle Database 10g software
[ ] Implement ASM failure groups
[ ] Create and manage as ASM instance
[ ] Create and manage ASM disk groups
[ ] Configure ASM for the shared disks, and create a clustered database
[ ] Configure archiving
[ ] Configure Services with a primary instance and an available instance
Data Guard
[ ] Use Data Guard Manager and DGMGRL
[ ] Create and utilize a physical standby database
[ ] Create and utilize a logical standby database
[ ] Set up log transport services for various levels or protection
[ ] Configure the network environment to allow communication between the standby database and the primary database
[ ] Open the physical standby database in a "ready-only" state
[ ] Perform a switchover operation and a failover operation
[ ] Implement Data Guard
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/38542/viewspace-985732/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- OCM exam guide - OCM認證指南GUIIDE
- 【徵文】OCM exam guide - OCM認證指南GUIIDE
- 【OCM】Oracle 10g OCM 考試大綱Oracle 10g
- Oracle 10g OCM Practicum Course PrerequisiteOracle 10gUI
- 通過oracle 10g ocm 認證Oracle 10g
- 拿到 oracle 10g ocm 電子證書Oracle 10g
- 【OCM】Oracle Database 10g: Performance Tuning(一)OracleDatabaseORM
- 【OCM】Oracle Database 10g: Performance Tuning(二)OracleDatabaseORM
- 【OCM】Oracle Database 10g: Performance Tuning(三)OracleDatabaseORM
- 【OCM】Oracle Database 10g: Performance Tuning(四)OracleDatabaseORM
- 【OCM】Oracle Database 10g: RAC for Administrators(一)OracleDatabase
- 【OCM】Oracle Database 10g: RAC for Administrators(二)OracleDatabase
- 【OCM】Oracle Database 10g: RAC for Administrators(三)OracleDatabase
- 【OCM】Oracle Database 10g: RAC for Administrators(四)OracleDatabase
- 【OCM】Oracle Database 10g: RAC for Administrators(五)OracleDatabase
- Book - Oracle Database 10g OCP Certification All-in-One Exam GuideOracleDatabaseGUIIDE
- 10g ocm 資訊顯示在oracle 官網上Oracle
- 【OCM】Congratulations! Oracle DBA 10g Certified Master Practicum ResultsOracleAST
- Oracle Database 10g OCP Certification All-in-One Exam Guide.pdfOracleDatabaseGUIIDE
- Oracle Database 10g OCP Certification All-in-One Exam Guide2OracleDatabaseGUIIDE
- Oracle OCMOracle
- 【OCM】Oracle 10g OCM官網個人主頁展示,紀念2年來與Oracle鬥志鬥勇Oracle 10g
- Topics
- Oracle Exam的排除法Oracle
- OCM 10G RAC安裝大綱
- 【OCM】Oracle 12c OCM 考試大綱Oracle
- 【OCM】Oracle 11g OCM 考試大綱Oracle
- Oracle OCM 認證指南Oracle
- Oracle 認證大師(OCM)Oracle
- ORACLE 11G OCM PASSOracle
- 【OCM】Oracle OCM11g考場合影~keep人生中重要時刻Oracle
- OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) errataOracleDatabaseGUIIDE
- C.exam.2
- 【OCM】Oracle 12C OCMU 12c OCM升級考試大綱Oracle
- 【OCP|OCM】Oracle培訓考證系列Oracle
- OCA-OCP Oracle Database 11g All-in-One ExamOracleDatabase
- Oracle 19c Concepts(17):Topics for Database Administrators and DevelopersOracleDatabaseDeveloper
- 10g和11g OCM考試環境軟體版本