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
A Correct answer
Explanation

A transaction in Oracle is defined as a logical unit of work that begins with the first SQL statement after a COMMIT or ROLLBACK (or at session start) and ends with the next COMMIT or ROLLBACK. This definition is correct - transactions span the statements BETWEEN two commit/rollback points.

Keep practicing — related questions