DEVFYI - Developer Resource - FYI

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
TRUNCATE
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)
Has
Doesn't fire database triggers
Does
It requires disabling of referential constraints.

(Continued on next question...)

Other Interview Questions