Multiple choice technology databases

You work as a database administrator for TCS .com. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?

  1. The instance would hang.

  2. The instance needs to be shut down.

  3. The instance would be in the open state.

  4. The instance would abort in such cases.

  5. The instance would be in the open and invalid state.

  6. The instance would in the open state, but all the background processes will be restarted.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When ALL control files are lost while the database is open, Oracle cannot continue operating without access to control file metadata. The instance immediately aborts and crashes. This is different from a graceful shutdown - it's an abrupt failure. The database cannot remain open or hang; it terminates immediately.

Keep practicing — related questions