1.

What Is Difference Between Truncate & Delete ?

Answer»

TRUNCATE commits after deleting ENTIRE table i.e., cannot be rolled back. Database triggers do not FIRE on TRUNCATE.
DELETE ALLOWS the FILTERED deletion. Deleted RECORDS can be rolled back or committed. Database triggers fire on DELETE.

TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE.
DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.


Discussion

No Comment Found

Related InterviewSolutions