The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR).
Examine the initialization parameters set in your database.
NAME TYPE VALUE
-------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring What is the location of the ADR base?

• A. It is set to /u01/app/oracle.
• B. It is set to /u01/app/oracle/flash_recovery_area.
• C. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
• D. It is set to /u01/app/oracle/admin/en12.1.0/adump.

Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- ---------------------------
0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.
What is the effect of this setting on the database?

• A. The overhead on database performance is increased because of frequent writes to disk.
• B. The MTTR advisor is disabled.
• C. The frequency of log switches is increased.
• D. Automatic checkpoint tuning is disabled.

Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?

• A. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• C. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the DUPLICATE command?

• A. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.
• B. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
• C. All archive redo log files are automatically copied to the duplicate database.
• D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
• E. The duplicate database has the same directory structure as the source database.

In which three scenarios is media recovery required?

• A. when all control files are lost
• B. when a tablespace is accidentally dropped from a database
• C. when archived redo log files are lost
• D. when data files are lost
• E. when one of the online redo log members is corrupted