If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?

• A. The command must be reissued with a more specific discovery string.
• B. The other disks, already part of the disk group, are ignored.
• C. The command fails unless you specify the REUSE option.
• D. The command fails unless you specify the FORCE option.

You issued the following RMAN command to back up the database: RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4;} Which two statements are true regarding the backup performed? (Choose two.)

• A. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
• B. Only data files are backed up and a restore point named FY06Q4 is created.
• C. Archived log files are backed up along with data files, and the archived log files are deleted.
• D. Archived redo log files are backed up along with data files.

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

• A. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
• B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
• C. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
• D. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash.
The steps to recover from the loss of a current redo log group member in the random order are as follow.
1) Restore the corrupted redo log group.
2) Restore from a whole database backup.
3) Perform incomplete recovery.
4) Relocate by renaming the member of the damaged online redo log group to a new location.
5) Open the database with the RESETLOGS option.
6) Restart the database instance.
7) Issue a checkpoint and clear the log.
Identify the option with the correct sequential steps to accomplish the task efficiently.

• A. Only 6 is required
• B. 1, 3, 4, and 5
• C. 2, 3, 4, and 5
• D. 7, 3, 4. and 5
• E. 7, 4, 3. and 5

You executed the following commands in a database session:

What could have caused the recycle bin to clean up?

• A. The new table name is the same as the table name in the recycle bin
• B. There is demand for space from the new table
• C. The temporary tablespace that is assigned to you does not have sufficient free space
• D. The undo tablespace does not have sufficient free space