Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25141 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / protyusha banerjee dawn
Whenever we delete records then they are stored in data
dictionary and can be retrieved later ie by roll back.
but when we truncate then the memory used by the records
which is to be truncated is released and it cannot be
rolled back.
| Is This Answer Correct ? | 24 Yes | 5 No |
Post New Answer View All Answers
What is trigger types of trigger?
What are the different sql commands?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the uses of sysdate and user keywords?
how would concatenate strings in mysql? : Sql dba
What is sqlcommand?
What is the process of copying data from table a to table b?
What is a subquery in sql?
How many triggers can be applied on a table?
How do you declare a user-defined exception?
How can we debug in PL/SQL?
Why is sql important?
what is transaction? : Sql dba
what are the security recommendations while using mysql? : Sql dba
What are the types of index in sql?
