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 end through multiple mechanisms: explicit COMMIT or ROLLBACK commands, implicit ending when a DDL (CREATE, ALTER, DROP) or DCL (GRANT, REVOKE) statement executes (which auto-commits), or when the user exits the tool or a system crash occurs. All four scenarios represent valid transaction termination points.

Keep practicing — related questions