Explain the difference between delete and truncate?
S.no | TRUNCATE | DELETE |
---|---|---|
1. | Rollback of the data is not possible | Rollback of the data is possible |
2. | All the records are deleted | Can delete a specific record using the WHERE condition. |
3. | Uses less transaction space | Use more transaction space |
BY Best Interview Question ON 16 Feb 2019