engineering computer science MCQ #743

What is the difference between TRUNCATE and DELETE?

engineering computer science MCQ #743

  1. Question 1

    Q1. What is the difference between TRUNCATE and DELETE?

    • A) TRUNCATE is used for DDL, while DELETE is used for DML
    • B) TRUNCATE is faster than DELETE
    • C) TRUNCATE can be rolled back, while DELETE cannot
    • D) Both A and B

    Answer: Both A and B

    Explanation: TRUNCATE is a DDL statement that is faster than DELETE because it doesn't log individual row deletions, and it cannot be rolled back unless in a transaction.