DS0-001 Question #114: Real Exam Question with Answer & Explanation

Question

Which of the following statements is TRUNCATE an example of?

Options

• ADDL statement
• BDCL statement
• CMCL statement
• DDML statement

Explanation

TRUNCATE is a DDL (Data Definition Language) statement because it operates on the structure and storage of a table itself - deallocating data pages and resetting the table - rather than manipulating individual rows of data. DDL statements define or alter database objects, and TRUNCATE falls into this category because it cannot be granularly rolled back in many databases and does not fire row-level triggers.

Why the distractors are wrong:

• B (DCL) - Data Control Language covers permissions and access control (GRANT, REVOKE).
• C (MCL) - This is not a real SQL classification; it's a made-up distractor.
• D (DML) - Data Manipulation Language (INSERT, UPDATE, DELETE, SELECT) works on individual rows of data. DELETE is the DML equivalent of TRUNCATE, but TRUNCATE is DDL because it bypasses row-level processing.

Memory tip: Think of it this way - DELETE removes rows one by one (DML), while TRUNCATE wipes the table's slate clean at the structural level (DDL). If it sounds like demolishing a building vs. removing furniture, it's probably DDL.

No community discussion yet for this question.