What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20391 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 the most restrictive isolation level? : Transact sql
How would you pass hints to the sql processor?
Does pl sql work in mysql?
Can you do multiple joins in sql?
What are the most important ddl statements in sql?
What are the two characteristics of a primary key?
How do you exit in sql?
What is relationship? How many types of relationship are there?
Does oracle roll back the transaction on an error?
What is varchar used for?
What is pl sql script?
What is a behavioral trigger?
What is query optimization in sql?
Which data type is a composite type?
How many times can we commit in a loop?
