Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6925 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 is dbms used for?
How to specify transaction or query timeout?
What are the four types of database?
What is an image database?
What are codd rules?
What is compound key?
Explain database partitioning and its importance.
Which database is best for large data?
What is data model and types?
What is database or database management systems (dbms)?
What is procedure in database?
What is the role of database management system?
What is n tier architecture in dbms?
How to connect Silverlight application to database?
describe and contrast a trigger and a procedure.
