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

Oracle database transactions end in multiple ways. Explicitly with COMMIT (save changes) or ROLLBACK (discard changes). Implicitly when a DDL statement (CREATE, ALTER, DROP) or DCL statement (GRANT, REVOKE) executes - these auto-commit. Also when user exits the client tool (iSQL*Plus/SQL*Plus) or if the system crashes (forced rollback/commit). Any of these events terminate the current transaction.

Keep practicing — related questions