engineering computer science MCQ #821

What is the difference between 'DROP' and 'TRUNCATE'?

engineering computer science MCQ #821

  1. Question 1

    Q1. What is the difference between 'DROP' and 'TRUNCATE'?

    • A) DROP deletes the table structure, while TRUNCATE deletes the data
    • B) TRUNCATE is faster than DROP
    • C) DROP is used for views, while TRUNCATE is used for tables
    • D) DROP is reversible, while TRUNCATE is not

    Answer: DROP deletes the table structure, while TRUNCATE deletes the data

    Explanation: DROP removes the table definition and its data, while TRUNCATE removes the data but keeps the table structure.