(Cognizant) Cognizant Test Practice Test
Cognizant Database Management Systems 2
What is the difference between DELETE and TRUNCATE in SQL?
Select your answer
A
DELETE is faster and cannot be rolled back; TRUNCATE can be rolled back
B
TRUNCATE removes all rows without logging individual deletions; DELETE logs each row deletion and can be rolled back
C
DELETE drops the table structure; TRUNCATE removes only data
D
There is no difference between DELETE and TRUNCATE
Hint
✨ Remove Ads & Unlock Every Exam
— From $1.49
🃏 Study This Quiz as Flashcards →
