what is the difference between delete and truncate?
- 4 Answers
- 5973 Views
- I also Faced
- E-Mail Answers
Answer Posted / nithya
The basic difference between delete and truncate is 'high
water mark'. High water mark indicates the max level to
which the data has risen in the table.
Deleting a table removes only the data from it whereas
Truncating a table removes all the data from the table and
resets the relevant pointers including 'high water mark'.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What database does facebook use?
How to configure events with firewall?
What is rank in database?
Write about Transaction Management in Oracle 9i?
What is vacuum in database?
What is the main purpose of database?
What is the best free database?
What are good databases?
What do you mean by transparent dbms?
What is the difference between a catalog and a database?
What is database join?
What is stored in a database?
What is difference between database and file?
What are the main components of a database system?
Can we save file in database?
