Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15791 Views
- I also Faced
- E-Mail Answers
Answer Posted / amsu
Truncate is a DDL and delete is a DML command. Once you
truncate a table you cannot rollback where as you can
rollback from the delete command. When you truncate a
table it release the space and it resets the highwater
mark. Delete won't release the space and it won't resets
the highwater mark.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why does Oracle not permit the use of PCTUSED with indexes?
Where would you look for errors from the database engine?
How to start SQL Server in minimal configuration mode?
What authentication modes does sql server support? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is logical system in sap basis
when does an alert gets signaled?
What purpose does the model database server? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is fill factor? : sql server DBA
what is the diffrence between core dba and apps dba?
how can a session indicate its interest in receiving alerts?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the importance of a recovery model? : sql server DBA
