Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25199 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
Why use subqueries instead of joins?
How do you go back in sql?
what are the types of join and explain each? : Sql dba
What do you mean by stored procedures? How do we use it?
What is rename command in sql?
What is program debugging?
explain what is mysql? : Sql dba
What is nested table in pl sql?
How do you change a value in sql?
What is the difference between having clause and where clause?
What does := mean in pl sql?
Can a table have no primary key?
How do you select unique values in sql?
Is sql a backend?
How many types of privileges are available in sql?
