http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [61]
02.File Book
File 자료실 [93]
Site Link [15]
개인폴더 [179]
03.Field Book
Altibase [15]
Tibero [21]
MS-SQL [17]
MySQL [27]
DB2 [75]
ORACLE [2385]
기타 DBMS [2]
기타정보 [134]
운영체제 [526]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [1]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: 게시판

 회원가입

2016 OCM 11g 준비중... [ 전남 광주에서 11g OCM 같이 스터디 하실분 연락 주세요. 010-8624-0835 ]
최길호  2016-04-12 16:41:08, 조회 : 1,797

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM&p_org_id=&lang=

11g OCM [ Oracle Database 11g Certified Master Exam ]

시험 환경

Oracle Linux Release 5.4 (32-bit)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit)
Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0)  (32-bit)

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


  LIST

제목 작성자 작성일 조회
 11g OCM 합격~♡   [1]  최길호 2017/08/05 702
 https://aws.amazon.com 메모    최길호 2016/09/23 836
 2016 OCM 11g 준비중... [ 전남 광주에서 11g OCM 같이 스터디 하실분 연락 주세요. 010-8624-0835 ]    최길호 2016/04/12 1797
 부고(訃告)  [1]  관리자 2014/05/12 11757
 DNS Server 불안으로 서비스 장애 발생 했습니다.    최길호 2014/04/06 2216
 TV조선-조선일보, 채널A-동아일보 '5.18 왜곡 방송'    최길호 2013/05/21 2399
 사용자 등록 공지 [ 가입을 환영 합니다. ]    관리자 2012/11/26 2485
 로그인 하지 않는 사용자 삭제 됩니다.    관리자 2012/04/07 2562
 DB2 개시판 추가 했습니다.    관리자 2012/04/07 2776
 최길호 Twitter: @gilhoker [ https://twitter.com/gilhokr ]    최길호 2012/01/16 2613
 최길호 사용자 검색 차단    관리자 2011/10/09 3193
 인텔 코어i7 980 , 24G 구입  [3]  최길호 2011/09/29 12438
 회원 가입 차단 공지  [1]  관리자 2011/09/04 3314
 서비스 중지 공지 [ 11/08/08 06:00 ~ 23:00 ]    최길호 2011/08/02 3112
 원격지원 프로그램  lv:2   최길호 2011/06/09 10757
 원격제어 프로그램 [ 고객용 ]  lv:2   최길호 2011/05/26 11113
 Auto Login Enable [ 한번 login하면 계속 유지 됩니다. ]  [3]  관리자 2011/03/02 12343

    목록보기   다음페이지 1 [2][3][4]
       

Copyright 1999-2019 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2019/04/15
축하드립니다~~^^
by 송승현
2014/05/12
늦게 알려드려 죄송합니다. 좋은 장소에 편...
by 최길호
2011/12/07
Level up 감사합니다. 날씨가 쌀쌀하니...
by 김성철
최근 게시물
11/20
[ORACLE]
12.2 mxx.trc wxx.trc lmhb.trc ....
by 최길호
11/20
[ORACLE]
OGG-00446.
by 최길호
11/06
[운영체제]
ssh_dispatch_run_fatal: Connec....
by 최길호