Multiple choice technology databases

In the following which is not a DDL ?

  1. Truncate

  2. Create

  3. Alter

  4. All the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

TRUNCATE is a DML (Data Manipulation Language) operation, not DDL. DDL includes CREATE, ALTER, DROP, TRUNCATE, and RENAME which define database structure. Despite some debate, TRUNCATE is classified as DDL because it deallocates data pages and resets identity values, unlike DELETE which is DML.

Keep practicing — related questions