Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25181 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy
Delete is associated with rollback segments like U can undo
it before committing and U have a choice of deleting a
specific row or rows where as
Truncate is not associated with rollback segments ie U cant
undo it and U cant delete a row/rows of ur choice
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what is offset-fetch filter in tsql? : Transact sql
Can sql function call stored procedure?
What is difference between stored procedure and trigger?
what happens if null values are involved in expressions? : Sql dba
Why do we need unique key in a table?
Does mysql support pl sql?
What are the advantages of indexing?
What is trigger and how to use it in sql?
Why procedure is used in sql?
What is a mutating table and a constraining table?
what is a view? : Sql dba
Why stored procedure is better than query?
Mention what plvcmt and plvrb does in pl/sql?
Which is faster view or stored procedure?
Is natural join same as inner join?
