Multiple choice technology databases

Which of the statement allows you to roll back and creates log in the transaction log?

  1. TRUNCATE

  2. DELETE

  3. DELETE ALL

  4. REMOVE

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DELETE is a logged operation that can be rolled back because it writes entries to the transaction log. TRUNCATE is minimally logged and cannot be rolled back. DELETE ALL and REMOVE are not standard SQL commands.