Question

does executing the commit or rollback statement and the current transaction?​

Answer 1

Answer:

• COMMIT statement allows the modification in the database after the current transaction is executed.

• ROLLBACK statement reverses all the updates of the database since the initial statement of current transaction.

• These SQL statements are actually used for modifying or reversing the transactional sequences.

• Once a transaction enters the COMMITED mode, it cannot be reversed and ROLLBACK statement will not be allowed there.  

• Usually, COMMIT statement is applied only after a successful transaction while ROLLBACK statement is used to erase the modifications if the transaction is discontinued in the midway.