Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11801 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / prabhanjan
1)Truncate will perform faster then delete.
2)When we truncate table triggers will not fire on delete
event.Where as for delete triggers will fire
3)After truncate table we can't roll back.
But for Delete we can roll back
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
After normalization, what are the conditions which have to keep in mind to de-normalize it?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is a database call?
Is redis in memory database?
Should I store images in database?
sparse lookup and where its options we find in OCI and db2?
Explain natural key?
What is difference between data and database?
Difference between sql and mysql?
What are different types of clusters present?
How do I manually create a database?
Is hive a database?
How heap is implemented in database?
What is odm in database?
List various types of log-based recovery in DBMS.
