SQL - What is the difference between COMMIT and ROLLBACK ?

GeekInterview.com > Placement Papers > Manhattan Associates > SQL

Go To First | Previous Question | Next Question

SQL | Question 3 of 4

What is the difference between COMMIT and ROLLBACK ?

Total Answers and Comments: 4

Last Update: June 13, 2005

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 14, 2005 15:40:44

kris

RE: What is the difference between COMMIT and ROLLBACK ?

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

Is this answer useful? Yes | No

May 09, 2005 07:58:32

Hari

RE: What is the difference between COMMIT and ROLLBACK ?

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

Is this answer useful? Yes | No

June 06, 2005 07:27:39

Nagaraja Rao s.k

RE: What is the difference between COMMIT and ROLLBACK ?

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

Is this answer useful? Yes | No

June 13, 2005 05:23:28

varsha

RE: What is the difference between COMMIT and ROLLBACK ?

one can't rollback the operations which has commited.

Is this answer useful? Yes | No