Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 3039 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vikas
When we use truncate data deletes permanently and can not recover.Truncate is fast because it not writes any thing in log file while perform deleting operations.
Delete is used to removed table data and it can be recover by using rollback . Delete is slow because it create log file before performing the delete operation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vikas
delete is slow because it creates log file while performing delete operations.We can recover data which is removed by using delete command by using rollback.
Truncate is fast because it does not create any log file while performing delete operation.We can not recover data which is removed by using truncate command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
How to assign a table row to a record variable?
What is a server parameter file in oracle?
What does `(+)` do in a where clause?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
Display the records between two range?
What is difference between sid and service name in oracle?
What are the advantages of Views ?
Explain the use of show option in imp command.
What is redo log?
if you update view? where we store the data?
What is MTTR advisor in Oracle?
Oracle General 
