FAQ

Q: Oracle Database 10g Administrator Certified Master Exam Topics

A:

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

Reference: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=10gOCM

Q:

A:

One Response to FAQ

  1. amr ismaeel says:

    good site

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: