Upgrade to Oracle Database 12c — Question 3

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

Answer options

• A. OMF cannot be used in a database that already has data files created with user-specified directions.
• B. The file system directions that are specified by OMF parameters are created automatically.
• C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• D. OMF automatically creates unique file names for table spaces and control files.
• E. OMF may affect the location of the redo log files and archived log files.

Correct answer: D, E

Explanation

Option D is correct because OMF is designed to automatically create unique file names for tablespaces and control files, enhancing file management. Option E is also correct as OMF can influence the location of redo log files and archived log files. Options A, B, and C contain inaccuracies regarding the capabilities and limitations of OMF.