Difference between delete and truncate.

Question

Accepted Answer

Delete removes rows one by one and can be rolled back, while truncate removes all rows at once and cannot be rolled back.

Delete is a DML command, while truncate is a DDL command.
Delete operation is slower as it generates a lot of undo and redo logs, while truncate is faster.
Delete can have a WHERE clause to specify which rows to delete, while truncate removes all rows in a table.
Delete can be rolled back using ROLLBACK command, while truncate cannot be rolled back.
Delete operation maintains the integrity constraints of the table, while truncate resets the identity of the table.

Accepted Answer

The DELETE command is used to delete particular records from a table. The TRUNCATE command is used to delete the complete data from the table. It is a DML command.

Difference between delete and truncate.

Top HCLTech Associate Process Manager interview questions & answers