Multiple choice technology programming languages

What is true for DELETE & TRUNCATE commands?

  1. Truncate command is same as delete command with no where clause.

  2. Data cannot be rolled back when Truncate command is used, while data can be rolled back when delete command used.

  3. Data cannot be rolled back when Delete command is used, while data can be rolled back when truncate command used.

  4. Both are DML commands.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE is a DDL operation that deallocates data pages and cannot be rolled back (even within a transaction). DELETE is a DML operation that logs individual row deletions and can be rolled back. TRUNCATE is also faster for large tables.

Keep practicing — related questions