Oracle
1Z0-072 · Question #3
Which three are true about Oracle Managed Files (OMF)? (Choose three.)
The correct answer is A. If DB_CREATE_FILE_DEST is specified, but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default. B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n. F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF. See the full explanation below for the reasoning.
Question
Which three are true about Oracle Managed Files (OMF)? (Choose three.)
Options
- AIf DB_CREATE_FILE_DEST is specified, but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
- BIf DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
- CIf only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
- DIf 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.
- EIf DB_CREATE_ONLINE_LOG_DEST_n is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_n by default.
- FIf only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.
How the community answered
(29 responses)- A76% (22)
- C14% (4)
- D3% (1)
- E7% (2)
Community Discussion
No community discussion yet for this question.