Free Oracle 11gocmu Exam Dumps Questions & Answers

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

• A.The tablespace must be offline before performing a Flashback Table recovery.
• B.If a significant number of changes have been made to the table, row movement must be enabled.
• C.An SCN is never used to perform a Flashback Table recovery.
• D.Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)

• A.Its entries are specific to a single database.
• B.It is globally available to all Oracle 11g databases on the machine.
• C.It contains file systems that have been mounted by the kernel NFS system.
• D.It contains file systems that have been mounted by Direct NFS.

View the exhibit and examine the output.
Which statement can be an inference from the output?
Exhibit:

• A.The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list
• B.The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group
• C.The least number of I/Os are performed on the last data file in the list
• D.The FRA disk group has an asynchronous I/O bottleneck

Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

• A.SET_ATTRIBUTE
• B.ENABLE_PROGRAM
• C.VALIDATE_PROGRAM
• D.ENABLE
• E.SET_ENABLED

When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instance's disk groups?

• A.IMMEDIATE
• B.TRANSACTIONAL
• C.ABORT
• D.NORMAL