What is difference between commit and rollback?

Answer»

COMMIT	ROLLBACK
Syntax: COMMIT;	Syntax: ROLLBACK;
USED to validate modifications made by current transactions	Used to erase modifications made by current transactions
After executing this, a TRANSACTION can’t be used for ROLLBACK	After executing this, a transaction can be modified and SENT for COMMIT
Occurs after SUCCESSFUL completion of a transaction	Occurs if transaction is abrupted unexpectedly

Discussion