Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between "as" and "is" in an oracle stored procedure?
How to pass parameters to procedures in oracle?
How oracle handles dead locks?
How to use like conditions in oracle?
What is oracle database 10g express edition?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is a dead lock in oracle?
Explain the use of record option in exp command.
What the is the diff between local index and global index. give some example.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Is truncate autocommit in oracle?
What do you understand by database schema and what does it hold?
Can we write dml statement in function in oracle?
What is merge in oracle?
What are the parameters that we can pass through a stored procedure?
