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 ROLLBACK?
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

ANSI defines abnormal termination of a program as equivalent to a ROLLBACK. This means that all changes made to the database during the transaction will be undone or rolled back. Therefore, option C, where the program is abnormally terminated, is the best option.

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