Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6726 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 do you understand by e-r model?
What is the default '-sort' order for a sql?
How a Store Procedure called with a cursor out parameter.?
What is database join?
What are the 4 types of database?
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
How to use multiple database server in back end ?
What do databases contain?
What is meant by database management system?
How do you notify dbpak about stored procedure?
Is it possible to declare or create a cursor for update of table? If no tell me why?
What are the importance of partitioning in dbms?
What is data modelling explain?
What is the difference between multiload and fastload interms of performance?
Who invented schema theory?
