Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24494 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
When can we use the where clause and the having clause?
Is left join faster than join?
What is cascade in sql?
what does the t-sql command ident_incr does? : Transact sql
Can you inner join the same table?
What is rollback?
What is oracle sql called?
what is normalization? : Sql dba
how can we submit a form without a submit button? : Sql dba
What is dialect in sql?
Is sql workbench free?
Are stored procedures compiled?
What are sql*plus environment variables?
What are % type and % rowtype?
What is rtm stands for?
