Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25233 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 foreign key? : Sql dba
How do you optimize a query?
Write the command to remove all players named sachin from the players table.
Is vs as in pl sql?
Can we use pl sql in sql server?
how to get a list of indexes of an existing table? : Sql dba
What is right join in sql?
How to make a copy values from one column to another in sql?
What is replication id?
Why do we use partitions in sql?
discuss about myisam key cache. : Sql dba
How can we make an if statement within a select statement?
What are the types of join and explain each?
Is sql better than excel?
Enlist the characteristics of pl/sql?
