Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25215 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 dynamic sql in pl sql?
How can we make an if statement within a select statement?
How does stored procedure reduce network traffic?
How to place comments in pl/sql?
Explain the steps needed to create the scheduled job?
Which sql statement is used to delete data from a database?
how to convert character strings to numeric values? : Sql dba
How do I count rows in sql query?
What is varchar example?
Can we enter data in a table in design view?
What is pivot query?
How many sql commands are there?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Can we insert data into view?
What is the most common sql injection tool?
