Multiple choice

Which of the following events performs the ROLLBACK automatically in a PL/SQL transaction?

  1. A CREATE TABLE statement is issued

  2. A COMMIT or a ROLLBACK statement is issued

  3. A DCL statement, such as a GRANT statement is issued

  4. A DML statement fails

  5. An UPDATE statement is issued
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is correct as a  ROLLBACK is automatically performed for undoing that DML statement.

Keep practicing — related questions