Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the different pseudo commands? Explain in general?
What do you mean by redo log file mirroring?
What privilege is needed for a user to connect to oracle server?
what is the dual table in oracle?
How to drop a tablespace?
How to export your own schema?
What is meant by joins? List out the types of joins.
What are the differences between char and nchar in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to omit columns with default values in insert statement in oracle?
Is primary key indexed by default in oracle?
Explain table?
How to manage transaction isolation level?
What operating systems are supported by oracle database 10g xe?
In the oracle version 9.3.0.5.0, what does each number shows?
