what is the difference between delete and truncate?
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
Where is data stored in a database?
How do you delete a table from database?
Explain the Surrogate Key in DBMS.
How index hunting contributes in improving the query performance?
State at least four kinds of indexing?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
For each user who needs access, the DBA creates an account in which database?
Explain 4nf?
What are the ways to tune reporting services?
What is procedure in dbms?
What are the four types of database?
How does notification services work?
What is domain in dbms?
What are indexes? What are b-trees?
Why indexing is used in database?