Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 3136 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 |
what is primary key and foreign key when and where have to use
How to convert csv to table in oracle?
How to rename a column in an existing table?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
How to drop an index in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to bring a tablespace online?
What is Virtual Private Database in Oracle?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
What is data type in oracle?
What is Oracle table?
What is redo log?
Oracle General 
