Multiple choice technology databases

Database transactions end with

  1. COMMIT or ROLLBACK

  2. A DDL or DCL statement executing

  3. USER exiting iSQL*Plus or System crash

  4. Any one of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Database transactions can end through explicit COMMIT or ROLLBACK commands, implicit commits triggered by DDL or DCL statements, or session termination (user exit or system crash). All three scenarios terminate the current transaction.

Keep practicing — related questions