What is the difference between COMMIT and ROLLBACK ?

Showing Answers 1 - 7 of 7 Answers

kris

  • Mar 14th, 2005
 

COMMIT - save work done ROLLBACK - restore database to original since the last COMMIT

  Was this answer useful?  Yes

Hari

  • May 9th, 2005
 

COMMIT - to commit the sql operations done so far. 
ROLEBACK - to revoke the SQL operation done so far

  Was this answer useful?  Yes

Nagaraja Rao s.k

  • Jun 6th, 2005
 

commit will save the transactions which has done so far 
where as rollback will do undo all the transactions which has done so far after commit

  Was this answer useful?  Yes

varsha

  • Jun 13th, 2005
 

one can't rollback the operations which has commited.

  Was this answer useful?  Yes

M.chidambaram

  • Jan 6th, 2012
 

* COMMIT is used to save the changes permanantly on the server

* ROLLBACK is used to undo the changes and restore previous state.

  Was this answer useful?  Yes

vanathi

  • Jun 9th, 2013
 

DROP & TRUNCATE can't be rolled back

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions