Question discussion

Which of the following statements is true about TRUNCATE in SQL (Structured Query Language)?

359408Medium DSSSB TGT Computer Science 0 replies 0 views
0
Which of the following statements is true about TRUNCATE in SQL (Structured Query Language)?
  • ATRUNCATE removes table structure.
  • BTRUNCATE does not remove data from the table.
  • CTRUNCATE is a DML command.
  • DTRUNCATE is faster than DELETE.
Correct answer: D

Explanation

TRUNCATE removes all rows quickly without logging each row, so it is faster than DELETE. It keeps the table structure and is a DDL command.

Discussion 0

Nobody has replied yet. Start the discussion!