Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24979 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / brajendra arzare
Deletes perform normal DML. That is, they take locks on
rows, they generate redo and they require segments in the
UNDO tablespace. Deletes clear records out of blocks
carefully. If a mistake is made a rollback can be issued to
restore the records prior to a commit.
Truncates are DDL and truncate moves the High Water Mark
of the table back to zero. No row-level locks are taken, no
redo or rollback is generated.so they have the same effect
as a delete, but without all the overhead. Just one slight
problem: a truncate is a DDL command, so you can't roll it
back if you decide you made a mistake. (It's also true that
you can't selectively truncate -no "WHERE" clause is
permitted, unlike with deletes, of course).
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is time based sql injection?
How will you distinguish a global variable with a local variable in pl/sql?
How to handle bulk data?
How many tables can a sql database have?
How many functions are there in sql?
Can we use views in stored procedure?
what is the functionality of the function htmlentities? : Sql dba
Which are the different case manipulation functions in sql?
What is recursive join in sql?
what are null values? : Sql dba
How can triggers be used for the table auditing?
What is bitemporal narrowing?
How can you create an empty table from an existing table?
Can we create a trigger on view?
How do you exit in sql?
