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
How to convert numbers to characters in oracle?
How to connect to oracle using service name instead of sid?
Explain joins in oracle?
What are the benefits of ordbms?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How can I combine multiple rows into a comma-delimited list in oracle?
What is transport network substrate (tns) in oracle?
How to use "for" statements in oracle?
How to add a new column to an existing table in oracle?
What happens to indexes if you drop a table?
How to display employee records who gets more salary than the average salary in the department?
What to do if the binary spfile is wrong for the default instance?
How do I connect to oracle database?
What are the components of logical database structure in oracle database?
what is IDE,DMV in sql server?