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 termination when a DDL (CREATE, ALTER, DROP) or DCL (GRANT, REVOKE) statement executes, or external events like user exit or system crash. All these scenarios can terminate a transaction, making 'Any one of the above' the correct answer.

Keep practicing — related questions