Question

What is generally done after the transactions are executed successfully?

(a) delete

(b) rollback

(c) commit

(d) update

This question was posed to me in an international level competition.

This interesting question is from Performing Transactions in chapter Using SQL to Manage Data of MySQL

Answer 1

Correct option is (c) commit

To explain I would say: In a transaction, either all the statements are executed successfully or neither of them are successful. This is facilitated by the commit and rollback capabilities. Commit is made after a transaction.