Multiple choice

In which situation would it be most beneficial to use OMF?

  1. The database's disk subsystem utilizes raw disk devices.

  2. Many user trace files exist that are no longer needed.

  3. A read-only database is maintained and used only to look up static information.

  4. A test database is being created and minimum administration effort is desired for the database.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle Managed Files (OMF) is most beneficial for test databases or environments where minimal administrative effort is desired. OMF automatically names and manages database files based on the DB_CREATE_FILE_DEST and related parameters, eliminating manual file placement decisions. Options A, B, and C describe scenarios where OMF is either incompatible (raw devices), unnecessary (old trace files), or irrelevant (read-only static databases) respectively.

Keep practicing — related questions