A transaction is completed on execution of a COMMIT or ____ statement,or a disconnection from a session.
A) SELECT
B) ROLLBACK
C) SAVEPOINT
D) INSERT

Question

Quizplus · Accepted Answer

A transaction can only be completed by either committing the changes made or rolling back to the previous state before the transaction started. A SELECT statement only retrieves data, while a SAVEPOINT creates a marker within the transaction for later rollback purposes. INSERT only inserts data into a table.

A Transaction Is Completed on Execution of a COMMIT or ____