What is Difference between Commit and Rollback when Used in Transactions?

As both ROLLBACK and COMMIT Commands are TCC (Transaction Control Commands), but are not similar to eachother. Here is the difference:

ROLLBACK Command
 ROLLBACK restore the state of the database to the last commit point.

COMMIT Command

It will make our changes permanent that cannot be rolled back.

No comments:

Post a Comment

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...