Which three RMAN persistent settings can be set explicitly? (Choose three.)

A. archivelog deletion policy

B. SPFILE backup duplexing

C. image copy duplexing

D. archivelog backup duplexing

E. redo log backup duplexing

F. controlfile autobackup formats

Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)

A. connecting to the target database and a recovery catalog to execute the duplicate command

B. creating a password file for an auxiliary instance

C. connecting to an auxiliary instance

D. matching the database identifier (DBID) of the source database and the duplicate database E. creating an SPFILE for the target database

Consider the following scenario for your database:

Backup optimization is enabled in RMAN.

The recovery window is set to seven days in RMAN.

The most recent backup to disk for the tools tablespace was taken on March 1, 2013.

The tools tablespace is read-only since March 2, 2013.

On March 15, 2013, you issue the RMAN command to back up the database to disk.

Which statement is true about the backup of the tools tablespace?

A. The RMAN backup fails because the tools tablespace is read-only.

B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.

C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.

Which method or feature should you use?

A. Database Replay

B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C. Active Session History (ASH) report

D. SQL Performance Analyzer

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

Examine the steps required to recover the database:

1.

Restore an autobackup of the server parameter file.

2.

Restore the control file.

3.

Start up the database instance in nomount state.

4.

Mount the database.

5.

Restore the data files.

6.

Open the database with the resetlogs option.

7.

Recover the data files.

8.

Set D3ID for the database.

Identify the required steps in the correct order.

A. 1, 8, 3, 2, 4, 5, 7, 6

B. 8, 1, 3, 2, 4, 5, 7, 6

C. 1, 3, 2, 4, 8, 5, 6, 7

D. 8, 3, 2, 4, 5, 7, 6

E. 8, 1, 3, 2, 4, 5, 6