Question

consider the following action transaction SQL>Commit;
SQL>Rollback;
What does rollback can do in the above statement?
A. Undo the transaction before commit.
B. Clear the transaction.
C. Turn back or goes back the transaction.
D. All of the mention
E. Nothing.

Answer 1

In the context of the provided SQL statements, the `ROLLBACK` command is used to undo changes made by a transaction before a `COMMIT` is executed. Therefore, the correct interpretation of what `ROLLBACK` can do in the above statements is:

**A. Undo the transaction before commit.**

Option A best captures the functionality of `ROLLBACK` in this context. Therefore, the answer is not D (All of the mentioned) because options B and C are not accurate in describing the specific effects of `ROLLBACK`.

So, the best single correct answer is:
**A. Undo the transaction before commit.**