SQL (Structured Query Language) Question:
Download Job Interview Questions and Answers PDF
What is the difference between TRUNCATE and DELETE commands?
Answer:
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
Download SQL Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Which system tables contain information on privileges granted and privileges obtained? | State true or false. EXISTS, SOME, ANY are operators in SQL? |