Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is ASM (Automatic Storage Management) in Oracle?
What is the data type of dual table?
How to download oracle database 10g xe?
How to define a sub function?
Does oracle charge for java?
How to add a new column to an existing table with a default value?
Can we protect our pl/sql source code?
What does sharding mean?
Whether any commands are used for months calculation? If so, what are they?
How to use "startup" command to start default instance?
What are the numeric comparison operations?
does the query needs a hint to access a materialized view?
How to rename an existing table?
How do I limit the number of rows returned by an oracle query after ordering?
Explain about your project and its relation to the current job position you are applying to?
