Free 11gocmu Questions for Oracle 11gocmu Exam

Question #1

What is the purpose of the recover command? (Choose all that apply.)

A. Recover required archived redo logs from physical disk backup sets.

B. Recover required incremental backups from physical disk backup sets.

C. Apply incremental backups to recover the database.

D. Recover database datafiles from physical disk backup sets.

E. Apply archived redo logs to recover the database.

Discussion 0

Correct Answer: A,B,C,E Vote an answer

Question #2

Which three actions are required to configure the Flashback Database? (Choose three.)

A. start the database in the ARCHIVELOG mode

B. set Flash Recovery Area

C. enable Flashback logging

D. start the database in the NOARCHIVELOG mode

E. create FLASHBACK tablespace

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #3

Which two statements about workload capture and replay operations are true? (Choose two.)

A. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

B. The clients must be created manually on the test machines to perform more realistic testing.

C. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

D. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

Discussion 0

Correct Answer: A,D Vote an answer

Question #4

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

A. generating baselines that include candidate SQLs for tuning

B. generating the SQL profile

C. tuning each SQL statement in the order of importance

D. adding tuned SQL plans into the SQL plan baseline

E. generating a list of candidate SQLs for tuning

F. testing and accepting the SQL profile

Discussion 0

Correct Answer: B,C,E,F Vote an answer

Question #5

You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?
1.Take the datafiles that were lost offline.
2.startup mount the database
3.Issue the alter database open command.
4.Restore the datafiles that were lost
5.Recover the datafiles with the recover datafile command.
6.Bring the datafiles back online.
7.Recover the database with the recover database command.

A. 2, 4, 5, 3

B. 2, 4, 7, 3

C. 4, 7, 3

D. 2, 1, 3, 4, 5, 6

E. 2, 7, 3

Discussion 0

Correct Answer: A Vote an answer

Question #6

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?
a.Shut down the database.
b.Take the users_01.dbf datafile offline with the alter database command.
c.Restore the users_01.dbf datafile from backup media with the required archived redo logs.
d.Restore all users tablespace-related datafiles from backup media.
e.Issue the recover tablespace users command.
f.Issue the recover datafile users_01.dbf command.
g.Start up the database.
h.Bring the users_01.dbf datafile online with the alter database command.

A. b, c, f, h

B. a, b, c, f, g, h

C. a, c, f, g

D. b, c, f, e, g

E. a, b, c, f, g

Discussion 0

Correct Answer: A Vote an answer

Question #7

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

A. The number of DBWR processes increases

B. The number of DBWR_TO_SLAVES increases

C. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

D. The number of ASMB processes increases

Discussion 0

Correct Answer: C Vote an answer

Question #8

You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN {
SET UNTIL SCN 1107600;
RESTORE DATABASE;
RECOVER DATABASE;
}
Which statement is true about the result?

A. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

B. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600

C. RMAN restores all datafiles and control files from the most recent backup

D. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.

Discussion 0

Correct Answer: D Vote an answer

Question #9

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans can be manually loaded to the SQL plan baseline.

B. The plans generated for every SQL statement are stored in the SQL plan baseline by default.

C. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

D. The plan baselines are stored temporarily in the memory as long as the database instance is running.

E. The plans in the SQL plan baseline are verified and accepted plans.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #10

Which of the following statements is true regarding implementing a Flashback Table
recovery?

A. If a significant number of changes have been made to the table, row movement must be enabled.

B. An SCN is never used to perform a Flashback Table recovery.

C. Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

D. The tablespace must be offline before performing a Flashback Table recovery.

Discussion 0

Correct Answer: C Vote an answer

Question #11

What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

A. Channel failover

B. Restartable backups

C. Channel recovery

D. Automatic backup recovery

E. Rescheduable backups

Discussion 0

Correct Answer: A Vote an answer

Free 11gocmu Questions for Oracle Database 11g Certified Master Upgrade 11gocmu Exam as PDF & Practice Test Engine

Download Free Oracle 11gocmu Demo