【OCM】Oracle 11g OCM 考試大綱

海星星hktk發表於2015-01-25

Oracle Database 11g Certified Master Exam


Exam Environment

  • Oracle Linux Release 5.4 (32-bit)
  • Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit)
  • Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0)  (32-bit)



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 a tablespace that uses NFS mounted file system file  
  • 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  
  • Configure the network environment to allow connections to multiple databases
  • Use configurationless connections
  • Use OPatch to install a patch
  • Use Grid Infrastructure to manage oracle databases and other resources
  • Use Enterprise Manager Configuration Assistant(EMCA) utility

Enterprise Manager Grid Control

  • Install and Patch 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 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

  • Mantain recovery catalogs
  • Configure Recovery Manager
  • Use Recovery Manager to perform database backups
  • Use Recover Manager to perform complete database restore and recovery operations
  • Configure RMAN
  • Create different types of RMAN backups to cater for different performance and retention requirements
  • Set Flashback Database parameters
  • Configure a Fast Recovery Area
  • Perform various recovery operations using Flashback technology

Data Management

  • Manage Materialized Views to improve rewrite and refresh performance
  • Configure and manage distributed materialized views
  • Create and Manage encrypted tablespaces
  • Manage Transport of tablespaces across platforms
  • Configure a schema to support a star transformation query
  • Administer external tables
  • Implement Data Pump export and import jobs for data transfer
  • Implement Data Pump to and from remote databases  
  • Configure and use parallel execution for queries
  • Use SQL*Loader
  • Administer, manage and tune parallel execution

Data Warehouse Management  

  • Administer partitioned tables and indexes using appropriate methods and keys 
  • Perform partition maintenance operations  
  • Maintain indexes on a partitioned table
  • Implement securefile LOB
  • Create and manage LOB segments  
  • Implement fine-grained access control  
  • Create and manage contexts
  • Administer flashback data archive and schema evolution
Performance Management  
  • Administer Resource Manager 
  • Use Result Cache 
  • Use multi column statistics 
  • Gather statistics on a specific table without invalidating cursors 
  • Use partitioned indexes 
  • Administer and tune schema object to support various access methods 
  • Interpret execution plan  
  • Use SQL tuning tools and features 
  • Use SQL Tuning Advisor 
  • Use SQL Access Advisor 
  • Use SQL Performance Analyzer
  • Configure baseline templates  
  • Use SQL Plan Management feature
  • Implement instance caging 
Grid Infrastructure and ASM
  • Install Oracle Grid Infrastructure 
  • Create ASM Disk Groups 
  • Create and manage as ASM instance
  • Implement ASM failure groups
  • Creating ACFS File System   
  • Start, stop, configure and administer Oracle Grid Infrastructure
Real Application Clusters  
  • Install the Oracle Database 11gR2 software
  • Configure ASM for the shared disks and create a clustered database   
  • Configure archiving  
  • Configure services using both Manual and Policy Managed methods 
Data Guard  
  • Create Physical Standby Database with real-time apply. 
  • Configure the data guard environment to reduce overheads of fast incremental backups on the primary database 
  • Configure the Observer 
  • Switchover and switch back  
  • Configure connect time failover
  • Convert the standby to a snapshot standby 
  • Configure archivelog deletion policy for the Dataguard configuration 


RECOMMENDED MINIMUM SKILLS AND EXPERIENCE:

  • 3-4 years of professional enterprise-level Oracle experience
  • Extensive experience with backup, restore and recovery operations
  • Proficient with SQL
  • Working knowledge of LINUX command language that includes:
    • Formatting and executing basic OS commands
    • Creating and navigating through directory structures
    • File management using copy, move, and delete
    • Linux environment text editors
    • Setting environment variables
  • The ability to locate and launch Oracle executables that include: 
    • RMAN utility
    • Oracle Net Manager
    • Oracle Net Configuration Assistant
    • OEM
    • Listener Utility
    • OMS
    • Oracle Password Utility
    • Database Creation Assistant
    • DGMGRL (for 11g OCM)
  • Proficient with Oracle Enterprise Manager
  • Proficient in using Oracle Net Manager and the Oracle Net Configuration Assistant to configure networking
  • Advanced knowledge and use of Oracle Enterprise Server technology and features
  • Familiarity navigating through online Oracle documentation
  • Proficient with using Mozilla 1.6 browser software


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29475508/viewspace-1413780/,如需轉載,請註明出處,否則將追究法律責任。

相關文章