What is the difference between truncate and delete? How would a full table scan behave after?
- 1 Answers
- 643 Views
- I also Faced
- E-Mail Answers
Answer / Vishwa Natri
DELETE removes rows from a table, leaving space for them to be reused. TRUNCATE also removes all rows from a table but it does not leave any space for reuse; instead, it deallocates the space occupied by the table. After a full table scan on a DELETE operation, the block will be marked as used until new data is inserted, while after a TRUNCATE, the blocks become available immediately for reuse.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of locks in database?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
How many redo logs should you have and how should they be configured for maximum recoverability?
What is the full form of dba?
What is the main function of database?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What is a database instance?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
what does the no logging option do? Why would we use it?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
What is the difference between a database and instance?
Oracle General 
