Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25573 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
What is pl sql block in dbms?
What are the properties of a transaction?
Is sql considered coding?
how to create a test table in your mysql server? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
What is the purpose of primary key?
How many triggers can be applied on a table?
What is the execution plan in sql?
how is myisam table stored? : Sql dba
What is sql keyword?
how to include character strings in sql statements? : Sql dba
What is Histogram?
what is union? : Sql dba
Whis is not false in primary key?
