Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

DBMS Interview Questions and Answers

Ques. What’s the difference between DELETE and TRUNCATE?
Ans.
Following are difference between them: 
  • DELETE TABLE syntax logs the deletes thus making the delete operations low. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table. So TRUNCATE table is faster as compared to delete table. 
  • DELETE table can have criteria while TRUNCATE can not. 
  • TRUNCATE table can not have triggers.
Is it helpful? Yes No

Most helpful rated by users:

©2020 WithoutBook