More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
What is different between TRUNCATE and DELETE?
The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas DELETE is a DML statement.
(Continued on next question...)
