What is the difference between DELETE and TRUNCATE?
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 do I view output in sql developer?
What is trigger types in sql?
What is trigger and stored procedure in sql?
What is %s in sql?
give the syntax of grant and revoke commands? : Sql dba
What is an intersect?
What is the difference between explicit and implicit cursors in oracle?
What are procedures used for?
What is sql deadlock?
what is sql profiler? : Sql dba
what are date and time data types in mysql? : Sql dba
What is difference between nchar and nvarchar?
Explain polymorphism in pl/sql.
What is file based approach?
Why do we use joins?