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:
Post a Comment