A transaction is terminated on the execution of a(n)____ command (explicit or implicit),or when a ROLLBACK command is issued.
A) COMMIT
B) END
C) EXIT
D) FINISH

Question

Quizplus · Accepted Answer

A transaction is terminated on the execution of a COMMIT command (explicit or implicit), which confirms the changes made during the transaction to the database, or when a ROLLBACK command is issued, which undoes the changes and cancels the transaction. Therefore, option A is the best choice. Option B is incorrect because END is not a recognized command to terminate a transaction. Option C (EXIT) is typically used to terminate a program, not a transaction. Option D (FINISH) is not a recognized command to terminate a transaction.

A Transaction Is Terminated on the Execution of A(n)____ Command