Which of the following is not correct for DELETE and TRUNCATE?

A. DELETE table can be rolled back
B. TRUNCATE table cannot have triggers
C. TRUNCATE table can have criteria
D. DELETE table can have criteria
Ans: C

Posted in: sql server 2008 mcqs