TRUNCATE statement in SQL is a __________ (A) DML statement (B) DDL statement (C) DCL statement (D) None of these

DDL

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

Data Definition Language (DDL) – It is a syntax which helps in modifying data present in the form of tables or indexes

Hence, the correct option is (B)

Was this answer helpful?

 
   

0 (0)

(0)
(0)

Choose An Option That Best Describes Your Problem

Thank you. Your Feedback will Help us Serve you better.

Leave a Comment

Your Mobile number and Email id will not be published. Required fields are marked *

*

*

BOOK

Free Class

Ask
Question