Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 2448 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 |
Can a property clause itself be based on a property clause ?
How to list all tables in your schema?
Why do you create or replace procedures rather that drop and recreate.
What is recycle bin in Oracle?
What is the difference between $oracle_base and $oracle_home?
When system tablespace is created?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to create a table index?
How to find out what privileges a user currently has in oracle?
Give the advantages and disadvantages of clusters.
What are the numeric comparison operations?
Oracle General 
