Multiple choice technology databases

A user executes a PL/SQL block containing complex data with several update and insert statements using multiple row subqueries and complex inline view. Under which of the following conditions will the database save the change after executing one or more PL/SQL blocks? (Choose two)

  1. When you disconnect from your session abnormally

  2. After PL/SQL block is executed successfully

  3. When you issue TRUNCATE command at SQL prompt

  4. When COMMIT command is issued

  5. When each UPDATE statement is executed
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Oracle databases save changes (commit) when a user explicitly issues a COMMIT command, or implicitly when a DDL statement like TRUNCATE is executed. Abnormal disconnection results in a rollback, while successful execution of a PL/SQL block or individual DML statements does not commit changes automatically.

Keep practicing — related questions