Multiple choice technology databases

A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A transaction begins with the first executable SQL statement (or after a previous transaction ends) and finishes with a COMMIT or ROLLBACK. It is not defined as the statements between two such commands, since a COMMIT/ROLLBACK terminates the current transaction rather than separating active ones.

Keep practicing — related questions