SQL (Structured Query Language) Question:
Download Job Interview Questions and Answers PDF
What is difference between TRUNCATE & DELETE?
Answer:
TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE
DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.
DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.
Download SQL Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the parameter substitution symbol used with INSERT INTO command? | What is SQL sub-query? |