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) All changes are aborted and returned to a previous consistent state.
D) The database is shut down for maintenance.

Question

Quizplus · Accepted Answer

ANSI defines a ROLLBACK as canceling all changes made since the last COMMIT or SAVEPOINT and returning to a previous consistent state. Choice C is the only option that aligns with this definition.

Of the Following Events, Which Is Defined by ANSI as Being