Multiple choice

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

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

  2. To minimise downtime

  3. To prevent further corruption of a damaged datafile

  4. To allow for automatic datafile recovery

  5. To reject the datafile automatically
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

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

Keep practicing — related questions