Oracle Database 11g: Administration I — Question 39

Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to /u01/oracle/db01.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)

Answer options

• A. RMAN backups
• B. data files
• C. archived redo logs
• D. temp files
• E. control files
• F. audit logs
• G. audit files
• H. redo logs

Correct answer: B, E, F, H

Explanation

The correct answer includes data files (B), control files (E), audit logs (F), and redo logs (H), as these are stored in the DB_CREATE_FILE_DEST location. RMAN backups (A), archived redo logs (C), temp files (D), and audit files (G) are not stored there based on the configuration provided.