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, use NORMAL, IMMEDIATE, or TRANSACTIONAL shutdown options. These ensure all transactions are complete and the database is cleanly closed. NORMAL waits for all users to disconnect. IMMEDIATE rolls back active transactions and disconnects users. TRANSACTIONAL waits for active transactions to finish. ABORT is unsafe for backup as it doesn't cleanly close the database - it's equivalent to pulling the plug.

Keep practicing — related questions