Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25138 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / p.rajasekar
Delete:
1.It is DML staement.
2.We can rollback the Data
3.We can apply Where condition.
4.Database triggers will fire on DELETE.
5.High water mark Model is not applied
Truncate:
1.It is a DDL statement
2.We cannot rollback
3.We can not apply Where condition
4.Database trigger will not fire
5.High water mark Model is applied
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
how many ways we can we find the current date using mysql? : Sql dba
What is sql deadlock?
Can instead of triggers be used to fire once for each statement on a view?
Inline the values in PL/SQL, what does it mean.?
What are the benefits of pl sql?
How do I run a query in pl sql developer?
What makes a good primary key?
what is a trigger? : Sql dba
Does pl sql work in mysql?
Which one is faster ienumerable or iqueryable?
What is sql architecture?
What are the various restrictions imposed on view in terms of dml?
When you have to use a default "rollback to" savepoint of plvlog?
What are the ddl commands?
How to get unique records from a table?
