Multiple choice technology databases

You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)

  1. ABORT

  2. NORMAL

  3. IMMEDIATE

  4. TRANSACTIONAL
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

For a consistent closed database backup using OS commands, the database must be shut down cleanly ensuring all data is written to disk. NORMAL waits for users to disconnect, IMMEDIATE/TRANSACTIONAL prevent new connections and rollback active transactions. ABORT is inconsistent - it doesn't roll back transactions, leaving database in an unrecoverable state for backup purposes.

Keep practicing — related questions