Topic : Oracle-Managed File(OMF)

What is the parameters to set in the init.ora if you create db using OMF(Oracle Managed Files)?


Answer :

Db_create_file_dest=
db_create_online_log_dest_1=

Show Answer Discuss

How do you kill a session from the database?


  • SQL>alter system kill 'sid,serial#';
  • SQL>alter system kill 'sid';

Answer :

SQL>alter system kill 'sid,serial#';

Show Answer Discuss

You decided to use Oracle Managed Files (OMF) for the control files in your database.Which initialization parameter do you need to set to specify the default location for control files if you want to multiplex the files in different directories?


  • DB_FILES
  • DB_CREATE_FILE_DEST
  • DB_FILE_NAME_CONVERT
  • DB_CREATE_ONLINE_LOG_DEST_n

Answer :

DB_CREATE_ONLINE_LOG_DEST_n

Show Answer Discuss

Max number of control files that can be multiplexed in an OMF database?


  • 1
  • 5
  • 8
  • Unlimited

Answer :

5

Show Answer Discuss

OMF database will improve the performance?


  • Yes
  • No

Answer :

No

Show Answer Discuss