Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25140 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 are null values? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
What is data profiling in sql?
What is nosql example?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
When is the update_statistics command used?
Explain what is an index?
what is schema? : Sql dba
What are aggregate functions in sql?
Is it possible to sort a column using a column alias?
Define a temp table?
Can we join tables without foreign key?
What is the difference between rollback and rollback to statements?
Does pl sql work in mysql?
What is the non-clustered index in sql?
