Free Download 10g OCM Oracle Database 10g Administrator Certified Master Exam Dumps
Duration: 2 Days
First Day:
|
Section 0: |
Create the Database |
45 Minutes |
|
Section 1: |
Database and Network Configuration |
120 Minutes |
|
Section 2: |
Grid Control Installation and Configuration |
120 Minutes |
|
Section 3: |
Database Backup and Recovery |
60 Minutes |
|
Section 4: |
Data Warehouse Management |
90 Minutes |
Second Day:
|
Section 5: |
Database Management |
120 Minutes |
|
Section 6: |
Database Performance Management |
120 Minutes |
|
Section 7: |
Oracle RAC Database Deployment |
105 Minutes |
|
Section 8: |
Data Guard Deployment |
60 Minutes |
NOTE: The exam starts promptly at 9:00 AM. Plan on finishing no sooner than 6:00 PM. Late arrivals are 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.
Section 0: Create the Database *45 Minutes
1. Database Setup and Undo Management
1.1 Run the minimum required scripts to complete the basic configuration of the PROD database.
1.2 Set up automatic undo management in the PROD database to support the following requirements:
1.2.1 Avoid ORA-01555 Snapshot too old errors for queries running up to 90 minutes on average.
1.2.2 The number or concurrent OLTP users will be approximately 120 during normal business hours.
1.2.3 The number or concurrent batch processes that will run in the evenings and weekends will approximately 12 to 15
****
1. vi .bash_profile
export ORACLE_SID=prod
export EDITOR=vi
2. vi /etc/oratab
prod:/u01/app/oracle/OracleHomes/db10g:N
3. create initPROD.ora
cat init.ora |grep –v ^# |grep –v ^$ > initprod.ora
——————-
db_name=prod
db_block_size=8192
compatible=’10.2.0.1.0’
sga_max_size=300m
sga_target=300m
log_buffer=524288
processes=250
control_files=(/u01/app/oracle/oradata/PROD/Disk1/ctrl1.ctl,
/u01/app/oracle/oradata/PROD/Disk2/ctrl2.ctl,/u01/app/oracle/oradata/PROD/Disk3/ctrl3.ctl)
audit_file_dest=’ /u01/app/oracle/admin/PROD/adump’
background_dump_dest=’ /u01/app/oracle/admin/PROD/bdump’
core_dump_dest=’ /u01/app/oracle/admin/PROD/cdump’
user_dump_dest=’ /u01/app/oracle/admin/PROD/udump’
undo_management=AUTO
See more from Full Version please visit http://www.lead2pass.com/10g-ocm.html