Question

TRUNCATE statement in SQL is a ____________.

• A. DML statement
• B. DDL statement
• C. DCL statement
• D. None of these

Answer 1

The correct option is B DDL statement

TRUNCATE statement in SQL is a DDL statement.

The TRUNCATE TABLE statement is a Data Definition Language (DDL) operation that marks the extents of a table for deallocation. The result of this operation quickly removes all data from a table, typically bypassing a number of integrity enforcing mechanisms.

A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include views, schemas, tables, indexes, etc.