sql real interview question and answer

 SQL Interview questions and answers

1. what is the difference between delete and truncate?

• we can rollback delete statement but can't rollback truncate.
• delete does not reset identity of table , truncate reset identity value
• delete lock row for deletion and truncate lock entire table.
• delete is data manipulation , truncate is data definition language
• we can use where with delete but can't use with truncate