What is the difference between DELETE and TRUNCATE commands?

Question

Team JKExamLibrary · Accepted Answer

DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.

What is the difference between DELETE and TRUNCATE commands? MCQ with Answer and Explanation

Solution (By JKExamLibrary)

Discuss this Question (0)

Practice More Database Management System (DBMS) Questions