Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25185 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satyajit patel
DELETE: DML, Manual Commit, Till not committed can be
rollback, can be applied for both row level as well as
table level, can be used in trigger, doesn't release memory.
TRUNCATE: DDL, auto commit, cann't rollback, applied table
level, cann't be used in trigger, releases memory.
In both cases structure remains.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Is not equal in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
tell me about various levels of constraint. : Sql dba
What is the difference between inner join and outer join?
Explain what is a view?
Which software is used for pl sql programming?
Is oracle and sql same?
What is exit statement?
How do I create a sql script?
What is recursive stored procedure?
Write a sql query to get the third highest salary of an employee from employee_table?
What is the difference between a procedure and a function?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is difference between stored function and application function?
How many types of relationship are there?
