Multiple choice

MARY used an ALTER DATABASE statement on her database to perform an online control file backup. In which mode is her database operating?

  1. FAILOVER

  2. FASTBACK

  3. ARCHIVELOG

  4. NOARCHIVELOG
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Online control file backups require the database to be in ARCHIVELOG mode, which enables continuous archiving of redo logs. In NOARCHIVELOG mode, the database must be shut down for consistent backups. FAILOVER and FASTBACK are not valid database modes. ALTER DATABASE with backup options requires ARCHIVELOG mode for online operation.

Keep practicing — related questions