Database Management Interview Question:

What is the difference between delete and truncate?

Submitted by: Administrator

Truncate is a DDL command, which has autocommit hence
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
Submitted by: Administrator