Multiple choice technology databases

TRUNCATE commnd fall into which category of SQL statements?

  1. DDL

  2. DML

  3. DCL

  4. TCL
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

TRUNCATE is classified as DDL because it resets table storage and cannot be rolled back, unlike DELETE which is DML. DDL commands implicitly commit and modify database structure or metadata. This distinction is crucial for understanding transaction behavior and data recovery options.

Keep practicing — related questions