Oracle Database 11g Certified Master Exam: 11g OCM Exam
11g OCM Questions & Answers
Exam Code: 11g OCM
Exam Name: Oracle Database 11g Certified Master Exam
Q & A: 9 Sections (Actual Labs)
•We provide actual 11g OCM Lab with questions and solutions
•Accuracy of 11g OCM Lab workbooks are over 95% correct
•90% of our students pass on the first try
•We offer One Year Free Update
All 83 pages
NOTE: This lab manual is a joint fruit of Lead2pass. If you have any questions or want to exchange experience, please go to http://www.lead2pass.com
Copyright © 2006-2013 LEAD2PASS SERVICES Ltd. All Rights Reserved.
Duration: 2 Days
NOTE:
The exam starts promptly at 9:00 AM.
Plan on finishing no sooner than 6:00 PM.
Late arrivalsare not guaranteed entry but may be accommodated at the sole discretion of the proctor.
Plan your travel schedule accordingly to ensure enough time to work through each scenario. Participants are not permitted to enter or leave the classroom once a skillset has started; they must wait until the next skillset.
Scoring
Participants are scored on their ability to complete assigned tasks and to recover from various database failure scenarios. Data from each participant’s environment is collected at the end of each scenario and used to determine the final score. In some scenarios, participants may receive partial credit, however the inability to recover from a failure scenario results in zero credit for an entire scenario. The proctor is not responsible for scoring the exam and will not have scoring information during the event.
Participants will be notified of their final score 4 – 5 weeks following the exam. Upon attaining a successful score, a participant is awarded the Oracle Certified Master credential.
Participants who do not earn a passing score are required to retake the entire exam at a later date.
——————————————DEMO VERSION———————————————-
Configuation of Virtual Machine
Virtual Machine Name: edgzrip1_Oracle Enterprise Linux
Virtual Machine Location: D:\ocm\edgzrip1
Host Name: edgzrip1
IP Adress: 192.168.3.101
Examination Requirements
Create a database manually, ORACLE_SID= prod
The same character set, the character set of prod and omr must be same, both are AL32UTF8
1.【Section 0】Create the database
1.5 Check and configure the environment variable
1.6 Create orapwd file
[oracle@edgzrip1 dbs]$ cd $ORACLE_HOME/dbs
[oracle@edgzrip1 dbs]$ orapwd file=orapwprod password=oracle entries=5
1.8 Create parameter files
[oracle@edgzrip1 dbs]$ vi initprod.ora
db_name=prod
memory_target=1G
processes = 150
audit_file_dest=’/u01/app/oracle/admin/prod/adump’
audit_trail =’db’
db_block_size=4096
db_domain=”
db_recovery_file_dest=’/u01/app/oracle/flash_recovery_area’
db_recovery_file_dest_size=2G
diagnostic_dest=’/u01/app/oracle’
open_cursors=300
remote_login_passwordfile=’EXCLUSIVE’
undo_tablespace=’UNDOTBS1′
undo_management=AUTO
control_files = (‘/u01/app/oracle/oradata/prod/control01.ctl’,’/u01/app/oracle/oradata/prod/control02.ctl’)
compatible =’11.2.0′
—————–See more from full version————————–
2.【Section 1】Server Configuration
2.7 Tablespace with parameters
1、 Create Table space management manual, unform size=1m
SQL> CREATE TABLESPACE users01
DATAFILE ‘/u01/app/oracle/oradata/prod/user01.dbf’ SIZE 10M
autoextend on maxsize 2g
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
segment space management manual;
2、 Set the default table space user01
SQL> alter database default tablespace users01;
3、 Create tablespace index, segment space management manual，
SQL> create tablespace index
datafile ‘/u01/app/oracle/oradata/prod/indx01.dbf’ SIZE 10M
autoextend on maxsize 2g
extent management local autoallocate
segment space management manual;
—————–See more from full version————————–
3.【Section 2】Enterprise Manager Grid Control
3.6 Deploy Enterprise Manager Grid Control agents
3.9 Perform various recovery operations using Flashback technology
—————–See more from full version————————–
4.【Section 4】Data Management
4.6 Query Rewrite
Example: Materialized view query rewrite
CREATE MATERIALIZED VIEW “SH”.”MV_TE1″
REFRESH fast ON DEMAND ENABLE QUERY REWRITE
AS
select c.cust_id,sum(amount_sold) as
dollar_sales,count(*),count(amount_sold)
from sales s,customers c
where s.cust_id=c.cust_id
group by c.cust_id;
SALES_CUSTOMER_FK 、CUSTOMERS_PK must be ENABLED/ VALIDATED
—————–See more from full version————————–
5.【Section 5】Data Warehouse Management
5.8 Virtual Column Partitioning
create table tvirtual(
xm varchar2(100),
gz number(10,2),
bl number(10,2),
tggz as (gz*(1+bl))
)
partition by range (tggz)
(
partition p1 values less than (1000),
partition p2 values less than (5000),
partition p3 values less than (10000),
partition pother values less than (maxvalue)
);
—————–See more from full version————————–
6.【Section 6】Performance Management
—————–See more from full version————————–
7. 【Section 7】Grid Infrastructure and ASM
—————–See more from full version————————–
8.【Section 8】Data Guard
—————–See more from full version————————–
go to http://www.lead2pass.com/11g-ocm.html to download the full version Q&As.