What is the difference between deleting all records from a table and truncating the table?
A)Deleting is faster
B)Truncating does not save roll back information while delete does
C)Only a DBA can truncate,anyone can delete
D)Delete does not save roll back information while truncate does

Question

Quizplus · Accepted Answer

Truncating a table does not save rollback information in the transaction log, which makes it faster than deleting all records. Deleting requires a rollback log to maintain the rollback information, which takes more time. However, anyone with proper permissions can perform both delete and truncate operations.

What Is the Difference Between Deleting All Records from a Table