Which of the following is true for TRUNCATE in SQL?

Question

A) It is usually slower than DELETE command

B) There is no comparison between DELETE & TRUNCATE

C) It is usually faster than DELETE command

D) None of these

Answer 1

The correct answer to the question “Which of the following is true for TRUNCATE in SQL” is option ©. It is usually faster than the DELETE command. And all the other options are incorrect for TRUNCATE in SQL. Wish to learn and master SQL? Enroll in Intellipaat’s SQL certification course, which offers you an industry-grade course to help you enhance your practical experience and skillsets. Also, look at the following YouTube video on SQL for Beginners and get started.