Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 2894 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the uses of linked server and explain it in detail?
if you update view? where we store the data?
What is the Tune Query
How to retrieve first and last records from a table?
11. Display the client number and name and the client number and name of the person who referred that client.
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to convert dates to characters in oracle?
Explain the dml?
What is system tablespace?
How to write a query with a full outer join in oracle?
What is blob datatype?
create one table to capture an employee details with a primary key.
Oracle General 
