What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20453 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 are the different schemas objects that can be created using pl/sql?
Can you have more than one trigger on a table?
Can I create table without primary key?
What is the mutating table and constraining table?
What is left inner join in sql?
how is myisam table stored? : Sql dba
Can we join more than 2 tables in sql?
What are sql injection vulnerabilities?
What are the different parts of a package?
What are the advantages of stored procedure?
What is orm in sql?
How do you write an inner join query?
What is count * in sql?
what is denormalization. : Sql dba
What is the execution plan in sql?
