Amdocs Interview Question
difference between DROP, TRUNCATE, DELETE which is fast and feasible.
Interview Answer
Anonymous
Aug 18, 2016
DROP and TRUNCATE are ddl commands and cant be rolled back. DELETE is DML command and can be rolled back. TRUNCATE and DELETE are similar, the only difference is the former cant be rolled back. DROP deletes table data as well as its structure from database. DELETE and TRUNCATE only delete the table data.