wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

TRUNCATE statement in SQL is a __________.


A

(A) DML statement

No worries! We‘ve got your back. Try BYJU‘S free classes today!
B

(B) DDL statement

Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
C

(C) DCL statement

No worries! We‘ve got your back. Try BYJU‘S free classes today!
D

(D) None of these

No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution

The correct option is B

(B) DDL statement


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)


flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Computers in Accounting
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon