Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24947 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
How does sql*loader handles newline characters in a record? : aql loader
How do you change a value in sql?
How many row comparison operators are used while working with a subquery?
Can we use view in stored procedure?
Why trigger is used in sql?
Explain the commit statement.
Can variables be used in sql statements?
What is difference between rank () row_number () and dense_rank () in sql?
Explain autonomous transaction.
What is nosql vs sql?
What is the difference between a database and a relational database?
how many groups of data types? : Sql dba
What is sharding in sql?
What is the difference between view and stored procedure?
Which is faster view or stored procedure?
