what is difference between delete and truncet ?
Answer Posted / shivaleela
DELETE:-
1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK
TRUNCATE:-
1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK
Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster
Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the best database?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What are indexes in oracle?
sparse lookup and where its options we find in OCI and db2?
what is transaction state, buffer management, shadow paging
how can we view column head in first page but not in remaining pages?
What is the importance of database partitioning?
List the properties of a transaction.
What is the role of tester in discovery(in Checklist)?
Explain the various types of normalization.
What is lagging in DBMS ?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
Explain partial key?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
What is odm database?