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
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
what is difference between sql plus and sql*plus? (not sql and sql plus).
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Explain view?
How to call a sub procedure?
Can you create a synonym without having a table?
How to run the anonymous block again?
List out the types of joins.
What are the different types of modules in oracle forms?
What is the max number of columns in an oracle table?
Can we write insert statement in function in oracle?
Is rowid unique in oracle?
What are the uses of a database trigger?
Can I create users through internet explorer in oracle 10g?
Explain the use of tables option in exp command.
