Differentiate between TRUNCATE and DELETE?
ORACLE Interview Questions and Answers (Part 3)
(Continued from previous question...)
515. Differentiate between TRUNCATE and DELETE?
TRUNCATE deletes much faster than DELETE
It is a DDL statement
It is a DML statement
It is a one way trip,cannot ROLLBACK
One can Rollback
Doesn't have selective features (where clause)
Doesn't fire database triggers
It requires disabling of referential constraints.
(Continued on next question...)
Other Interview Questions