Multiple choice technology databases

Your database is in NOARCHIEVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?

  1. Hot backup

  2. Online backup

  3. Consistent backup

  4. Incremental backup

  5. Inconsistent backup
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In NOARCHIVELOG mode, you cannot perform hot (online) backups because the database must be shut down cleanly to ensure a consistent backup. A consistent backup requires the database to be closed with all changes written to disk (consistent state). Hot/incremental backups require ARCHIVELOG mode to apply archived logs during recovery.

Keep practicing — related questions