what is difference between delete and truncet ?
- 7 Answers
- 9571 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
List some advantages of dbms.
What the various ways to tune a teradata query
Define stored procedure?
Is database a hardware or software?
How concurrency problems effect the database?
Explain the table term used in database.
Can you tell any two advantages of stored procedures?
how can we view column head in first page but not in remaining pages?
What is database client?
what is rcp,if rcp disabled what happen?
How do I manually create a database?
What advantages does DBMS have over traditional file systems?
What is a sequence? Explain it with one example?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
What is the role of driver manager?
