What is the difference between rollback and commit commands?

Posted By: shanthicse

Date: 21 September 2009 09:47:19 PM

Answer:

COMMIT command is used to make all the changes permanent to the underlying database which we made during the current transaction. ROLLBACK command is used to end the current transaction and undo all the changes we made since the current transaction began. Current transaction ends when we execute a COMMIT or ROLLBACK command, but the difference is that COMMIT command makes all the changes permanent while ROLLBACK command undo all the changes.
Posted By: Mike	Date: 30 September 2009 06:56:35 PM
These are Sql commands. Rollback is used to revert the last transaction in the Sql. Commit is used to save all the recent transactions.
Posted By: Johndecruse	Date: 13 February 2010 12:29:32 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

What is a Candidate key?

Candidate key is a set of one or more attribute other than primary key that can uniquely identify a ....

Category: Database

Date: 8/20/2009 3:02:40 AM

A foreign key is a referential constraint between two tables. The foreign key identifies a column or....

Category: Database

Date: 8/20/2009 3:01:26 AM

Primary key is the unique identifier for a record in the table. Here record refers to the value in t....

Category: Database

Date: 8/20/2009 2:57:19 AM

DBMS is a system where all interrelated data is atored and it allows the user to access data, modify....

Category: Database

Date: 8/20/2009 2:56:07 AM

System.XML

Category: Database

Date: 7/25/2009 6:26:47 PM

View All Questions >>

Signup for our weekly email newsletter