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
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Can we write dml statement in function in oracle?
Explain the use of file option in exp command.
How to use subqueries with the exists operator in oracle?
What is oracle open database communication (odbc)?
What is index-organized table in Oracle?
Name the three major set of files on disk that compose a database in Oracle?
ABOUT IDENTITY?
Difference between hot backup vs. Cold backup?
What are the different oracle database objects?
What is where clause in oracle?
How to use "in" parameter properly?
How do I reset a sequence in oracle?
State and explain about oracle instance?
Difference between inner join vs where ?
