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.


Correct Option: D

Find more quizzes: