Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24472 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
Which are the different case manipulation functions in sql?
What is rank function in sql?
How do you update a table in sql?
What is the source code of a program?
What is the difference between null value, zero, and blank space?
What is the difference between union and union all command?
what tools available for managing mysql server? : Sql dba
What is the purpose of a secondary key?
Is sql harder than python?
what are ddl statements in mysql? : Sql dba
What is a constraint?
How do I restart sql?
Which join is like inner join?
What is sql and its types?
How to run sql functions in pl/sql?
