What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 21928 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 rename in sql?
What is a trigger in sql?
What are the dml statements?
What are joins in sql?
Describe different types of general function used in sql?
What is the difference between local variables and global variables?
What is use of trigger?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Can we call procedure in select statement?
How to call shell script from pl sql procedure?
What is character functions?
What is procedure explain with program?
how to load data files into tables with 'mysqlimport'? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
