ANSI defines four events that signal the end of a transaction.Of the following events,which is defined by ANSI as being equivalent to a COMMIT?
A)Five SQL statements are executed.
B)The end of a program is successfully reached.
C)The program is abnormally terminated.
D)The database is shut down for maintenance.

Question

Quizplus · Accepted Answer

The end of a program being successfully reached is defined by ANSI as equivalent to a COMMIT, as it ensures that all updates have been made permanent and the transaction is completed successfully. The other options do not reflect the completion of a transaction in the same way as a COMMIT.

ANSI Defines Four Events That Signal the End of a Transaction.Of