Multiple choice

Which of the following statements is/are incorrect about 'SAVEPOINT' clause in Rollback statement in PL/SQL?

  1. It is used to undo all the changes for the current session.

  2. It is used to force the rollback of a transaction that may be corrupt or in doubt.

  3. ROLLBACK TO SAVEPOINT savepoint 1 is the syntax for this clause.

  4. ROLLBACK WORK TO SAVEPOINT savepoint 1 is the syntax for this clause.

  5. Both (2) and (3)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is called 'FORCE' clause in Rollback statement.

Keep practicing — related questions