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
What is gpt format?
What are sql ddl commands?
Enlist the characteristics of pl/sql?
What does bitemporal mean?
What is a record in a database?
What is raid? How does it help storage of databases?
what is cursor. write example of it. What are the attributes of cursor.
Is pl sql and postgresql same?
What are all the different normalization?
How exception is different from error?
Can dml statements be used in pl/sql?
What is the use of non clustered index?
What are the operators used in select statements?
What is constant in pl sql?
What is set serveroutput on?