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
Write a trigger example in oracle?
What are the parameters that we can pass through a stored procedure?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to write a query with an inner join in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How can you merge two tables in oracle?
Why packages are used in oracle?
Give the various rollback segment states.
What suggestions do you have to reduce the network traffic?
How to put more than 1000 values into an oracle in clause?
What is a sub query and what are the different types of subqueries?
What is the scope of a local variable?
How to work with data objects interactively?
What is the difference between postgresql and oracle?
Explain oracle’s server parameter file.
