Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6917 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 data independence?
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....
What are the basic components of notification services?
What is alternate key?
Explain the different types of database keys?
What do you mean by DBMS?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??
What do you understand by fragmentation?
What is use of foreign key?
Explain what are the two types of oltp?
What is data model in dbms?
What is database in simple language?
What is a database in layman terms?
What is normal form in dbms?
