Oracle 11gocmu Actual Free Exam Questions & Community Discussion

Exam Code/Number: 11gocmu
Exam Name/Title: Oracle Database 11g Certified Master Upgrade Exam
Certification Provider: Oracle
Corresponding Certification: Oracle Database 11g

Exam Questions: 673
Updated On: Aug 08, 2026

Question #1

Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?

A. restore database files until time '09/28/2008:18:00:00';

B. recover database until time '09/28/2008:18:00:00';

C. restore datafiles until time '09/28/2008:21:03:11';

D. restore database until time '09/28/2008:18:00:00';

E. recover database until timestamp '09/28/2008:18:00:00';

Discussion 0

Correct Answer: D Vote an answer

Question #2

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

A. Backup retention policy

B. Default backup device type

C. Default section size for backups

D. Multiple backup device types for single backup

E. Default destinations for backups

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #3

In which cases is reference partitioning effective in enhancing performance?

A. It is effective only in partition pruning.

B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

C. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

D. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

Discussion 0

Correct Answer: C Vote an answer

Question #4

What does the minimize load database parameter mean when backing up a database?

A. RMAN will spread the backup IO over the total duration stated in the backup command.

B. RMAN will attempt to make the backup run as fast as possible without any IO limitations.

C. RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.

D. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.

E. RMAN will automatically restrict the number of channels in use to one.

Discussion 0

Correct Answer: A Vote an answer

Question #5

In what view are you likely to see the following output?
SID SERIAL# EVENT SECONDS_IN_WAIT
121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63
130 270 SQL*Net message from client 8

A. V$WAITSTAT

B. V$SYSSTAT

C. V$SESSION_EVENT

D. V$SESSION

E. V$WAITS

Discussion 0

Correct Answer: D Vote an answer

Question #6

Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)

A. the latest backup of only the damaged data file

B. the latest backup of all the data files In the USERS tablespace

C. temporary files of temporary tablespace

D. control file

E. redo logs

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #7

If a backup is expired, which of the following is true?

A. The backup is no longer valid because of a resetlogs operation.

B. The backup has been used at least once to restore and recover the database.

C. It can never be used for a restore/recover operation.

D. The physical backup set pieces are missing from the media.

E. Oracle will remove the backup set pieces from the flash recovery area.

Discussion 0

Correct Answer: D Vote an answer

Question #8

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?

A. Specify undo retention guarantee for the database.

B. Enable Flashback Data Archive for the tables.

C. Enable supplemental logging for the database.

D. Create Flashback Data Archive on the tablespace on which the tables are stored.

E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 11gocmu Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 11gocmu exam.