Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 3049 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 is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
Can you assign multiple query result rows to a variable?
Explain about integrity constraint?
What is format trigger?
Explain coalesce function?
How many types of synonyms in Oracle?
How to create a new table by selecting rows from another table?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to bring a tablespace online?
without using count(*) and rownum how can we count total record in a table
What are a collation and state the different types of collation sensitivity?
What happens if recursive calls get out of control?
Oracle General 
