Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24983 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 does pl sql developer do?
What are the datatypes available in pl/sql ?
What are the commands used in sql?
Difference between table function and pipelined function?
What is difference between my sql and sql?
What is a data definition language?
what are the performance and scalability characteristics of mysql? : Sql dba
Is stored procedure faster than query?
What are string functions in sql?
What is a full join?
what is the difference between a local and a global temporary table? : Sql dba
what are different types of collation sensitivity? : Sql dba
What is sql deadlock?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is synchronized subquery?
