What is the difference between COMMIT and ROLLBACK ?

Showing Answers 1 - 7 of 7 Answers


  • Mar 14th, 2005

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

  Was this answer useful?  Yes


  • 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


  • Jun 13th, 2005

one can't rollback the operations which has commited.

  Was this answer useful?  Yes


  • 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


  • 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