Which two statements are true about Oracle Managed Files (OMF)?
A.
OMF automatically creates unique file names for table spaces and control files.
B.
OMF can be used with ASM disk groups, as well as with raw devices, for better file
management.
C.
OMF cannot be used in a database that already has data files created with user-specified
directions.
D.
OMF may affect the location of the redo log files and archived log files.
E.
The file system directions that are specified by OMF parameters are created
automatically.
Explanation:
A but with datafiles not tablespaces
D
BD
Oracle ASM also uses the Oracle Managed Files (OMF) feature to simplify database file management. OMF automatically creates files in designated locations. OMF also names files and removes them while relinquishing space when tablespaces or files are deleted.
B is incorrect. OMF is not meant for raw devices.
A and D are correct.
D- Though archive logs are not Oracle Managed files, but FRA which is oracle file management way, impacts where archivelogs can be kept.