what is the difference between delete and truncate?
Answer Posted / kadambari
Difference between Delete and Truncate :-
1. Truncate is a DDL statement hence it implicitly commits;
Delete is a DML statement hence we have to manually perform
commit.
2. Truncate doesn't fire the delete trigger hence it is
faster than Delete operation.
3. Once Truncated, data cannot be roll-backed; Delete
operation can be roll-backed.
4. Truncate resets the High water mark and frees up all the
extents; Delete doesn't reset the High water mark.
Thanks
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain primary key and composite key.
Which is the best database?
What is a data type in a database?
What is a relation in dbms?
Explain the Normalized Relations?
Mention some disadvantages of query?
Is sql a rdbms?
How do you rename a database?
What is the normal procedure followed by a java client to access the db?
Why do we need to use a database?
Define "correlated subqueries".
What is database management used for?
Define database lock and its types.
What you mean by Object Relational DBMS?
What is bcnf?