Which three statements are true about Oracle Managed Files (OMF)?
A.
If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
B.
If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.
C.
If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.
D.
If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.
E.
If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.
F.
If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
The Answer Is:
A, C, D
This question includes an explanation.
Explanation:
A.True. Without DB_CREATE_ONLINE_LOG_DEST_n, redo logs and control files default to DB_RECOVERY_FILE_DEST.
B.False. If only DB_CREATE_FILE_DEST is set, redo logs and control files also use it unless overridden.
C.True. DB_CREATE_ONLINE_LOG_DEST_1 becomes the default for data files and temp files if DB_CREATE_FILE_DEST is unset.
D.True. DB_CREATE_FILE_DEST serves as the default for all file types if no log-specific parameter is set.
E.False. Data files and temp files would also use DB_CREATE_ONLINE_LOG_DEST_1 if no other parameter is specified.
F.False. No such requirement exists; DB_RECOVERY_FILE_DEST operates independently.