Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11444 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
What is Object Oriented model?
When should you not use firebase?
diff b/w inter process and in process
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What is the use of default key?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
What is relational database with example?
What is database server and how it works?
What is the difference between database and server?
Is it good to store images in database?
What is a database example?
What do you mean by database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What are different types of joins used in?
What is database collection?
