Multiple choice technology databases

What is the key difference between TRUNCATE TABLE and DELETE FROM TABLE commands?

  1. TRUNCATE is DDL and DELETE is DML

  2. TRUNCATE is DML and DELETE is DDL

  3. TRUNCATE is DCL and DELETE is DML

  4. TRUNCATE is DML and DELETE is DCL
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

TRUNCATE is a Data Definition Language (DDL) command that quickly deletes all rows by deallocating the table's storage, which cannot be rolled back. DELETE is a Data Manipulation Language (DML) command that removes rows one by one, generating undo logs that allow rollbacks.

Keep practicing — related questions