Tuesday, February 24, 2009

Oracle Database 10g Administrator Certified Master Exam

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=176&p_canguid_id=ocm#5b

Oracle Database 10g Administrator Certified Master Exam

Recommended Experience and Preparation
  • 3-4 years of professional enterprise-level Oracle experience

  • Extensive experience with backup, restore and recovery operations

  • Proficient with Oracle 10g SQL

  • Working knowledge of LINUX command language that includes:
    Formatting and executing basic OS command
    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

  • 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

Additional Information About the Exam
  • Oracle Database 10g Rel. 2 (10.2.0.2)

  • Oracle Enterprise Manager Rel. 2 (10.2.0.2)

  • Oracle Database 10g Rel. 2 (10.2.0.1) - For RAC Only

Operating System:
  • For Candidate machines (both ODD and Even): Red Hat Enterprise Linux AS release 4 (Nahant Update 2)

  • For RAC Cluster nodes: Red Hat Enterprise Linux AS release 3 (Taroon Update 7)

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 preferred 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

No comments: