Oracle Database 11g Certified Master Upgrade Exam

受験前提条件
試験環境について
試験環境公式ページ
試験内容公式ページ

テスト内容チェックリスト

Database, RMAN, EM and Network Configuration
[ ] Configure server-side network
[ ] Configure client-side network
[ ] Create and Manage encrypted tablespaces
[ ] Create and Manage a tablespace that uses NFS mounted file system file
[ ] Set up ADR file based repository
[ ] Perform cold database backup
[ ] Manage user accounts and use case sensitive passwords
[ ] Use OPatch to install a patch
[ ] Install and configure EM Agent
[ ] Create Base Recovery Catalog
[ ] Configure RMAN
[ ] Perform multisection backup of a datafile
[ ] Create an Archival Backup

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
[ ] Convert the standby to a snapshot standby
[ ] Configure archivelog deletion policy for the dataguard configuration

Data and Data Warehouse Management
[ ] Troubleshoot fast materialized views to fast refresh and query rewrite
[ ] Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace)
[ ] Configure a schema to support a star transformation query
[ ] Configure and use parallel execution for queries
[ ] Use and access SecureFile LOBS
[ ] Create partitioned tables (includes reference and interval partitioning)
[ ] Configure Flashback Data Archive
[ ] Use Oracle Streams to capture and propagate changes in a table

Performance Management
[ ] Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc
[ ] Use Result Cache
[ ] Use multi column statistics
[ ] Gather statistics on a specific table without invalidating cursors
[ ] Use partitioned indexes
[ ] Use SQL Tuning Advisor
[ ] Use SQL Access Advisor
[ ] Configure baseline templates
[ ] Use SQL Plan Management feature
[ ] Replay a captured workload

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License