Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6872 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
Explain what are the two types of oltp?
What is the default '-sort' order for a sql?
How to prevent firebird.log file from filling up the disk partition?
Explain what are triggers and rules?
What is key dbms?
Explain 5nf?
How do databases help businesses?
What is database partitioning?
How is rdbms different from dbms?
How many types of users in dbms?
What is raid controller technology?
How do you backup a database?
Explain 4nf?
Enlist some commands of ddl?
What do you mean by denormalization?
