OCM考纲
来源:互联网 发布:excel2003 sql 编辑:程序博客网 时间:2024/04/30 01:33
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 pa rtitioned 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来源: <http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM>
- OCM考纲
- 10g OCM考纲
- Oracle 12c OCM 直考体验
- 甲骨文oracle的ocp和ocm认证难不难考?
- 昨天终于把OCM考完了(写了下总结)
- Oracle 12c OCM大师认证直考Hands on过程解析
- 晒晒OCM
- 软件考试考纲
- 软件设计师考纲
- 软件设计师考纲
- RHCE 考纲
- ocp11考纲
- NOIP考纲
- 软件设计师考纲
- NOIP考纲 图论
- 考
- 考
- OCM认证指南
- 解决VMware虚拟机在netcore nw703路由器下无法上网的问题
- oracle中BLOB和CLOB的区别
- Linux shell cat 初阶用法
- 华为2014机考样题及答案
- Seven_Training
- OCM考纲
- php获取本周周一、周日时间,上周周一、周日时间,本月第一天,本月最后一天,上个月第一天,最后一天时间
- 基于 Linux 和 MiniGUI 的嵌入式系统软件开发指南五——MiniGUI 1.1.0 版本引入的新 GDI 功能和函数
- 网络编程总结以及TCP与UDP
- 我的viewpad7
- JAVA---斐波那契数列
- 关于左值和++操作符
- 隐马尔可夫模型(HMM)攻略
- GUI总结概要