Multiple choice

Why should a datafile be set to offline when the database is in MOUNT state?

  1. To minimise downtime

  2. To prevent further corruption of a damaged datafile

  3. To allow automatic recovery of the datafile

  4. To recover it later, when database is in NOARCHIVELOG mode

  5. To maximise uptime
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When the database is in MOUNT state, a datafile is set to offline to allow its automatic recovery.

Keep practicing — related questions