UTpaper

Free mock tests & test series

Question 4Asked in DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)

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

Which of the following statements is true about TRUNCATE in SQL (Structured Query Language)?
  1. ATRUNCATE removes table structure.
  2. BTRUNCATE does not remove data from the table.
  3. CTRUNCATE is a DML command.
  4. DTRUNCATE is faster than DELETE.
Show answerHide answer

Correct answer: (D) TRUNCATE is faster than DELETE.

Explanation

TRUNCATE removes all rows at once with little logging and no row-by-row triggers, so it is faster than DELETE. It keeps the table structure and is a DDL command.

From DSSSB TGT Computer Science PYQ (Technical), 13 Sep 2025, Shift 3 (5:00 PM)

This is question 4 of DSSSB TGT Computer Science PYQ (Technical), 13 Sep 2025, Shift 3 (5:00 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.