Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).

• A. Recovery is faster if data is stored in catalog in addition to the control file.
• B. You can store backup information of all registered databases in one place.
• C. Database backups are automatically deleted when they are older than the specified time period.
• D. You can use RMAN stored scripts.

Your database is open and running in ARCHIVELOG mode.
You take RMAN full backups every Sunday night.
On Monday morning, while querying the user1.emoloyees table, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf*
You need to recover from this while ensuring that:
1.The data file remains online.
2.Mean Time To Recover (MTTR) is minimized as much as possible
You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?

• A. perform a table point in time recovery with datapump export and import
• B. use the DBMS_REPAIR package
• C. flash back the corrupted blocks
• D. use the RMAN BLCCKRECOVER command
• E. use RMAN tablespace point in time recovery

Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; }
Which statement is true about the duplicate database in this scenario?

• A. It contains all data except that which is used by the transactions in the current online redo file of target database
• B. It contains all data from target database until the current time
• C. It contains all data from only the committed transactions in the target database
• D. It contains data till the last backup

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
• B. SQL*Plus provides the ADRI script, which can be used to work with ADR
• C. The ADR base keeps all diagnostic information in binary format
• D. The ADR base is shared across multiple instances
• E. The ADR can be used for problem diagnosis only when the database is open
• F. The ADR can be used for problem diagnosis even when the database instance is down

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?

• A. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.
• B. You must take the tools01.dbf data file offline before you start a block media recovery.
• C. You must ensure that the SALES database is mounted or open.
• D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E. You must restore a backup control file to perform a block media recovery.