Examine these statements which execute successfully: The statements executed without exception. Which two are true?

Question

Exhibit

Options

• ANo transaction commits.
• BOne row is inserted into band.
• CTwo transactions commit.
• DNo row is inserted into band.
• EThe transaction is rolled back to the savepoint.

• A
  73% (22)
• C
  17% (5)
• D
  7% (2)
• E
  3% (1)

Explanation

Without the actual SQL statements shown, this question follows a classic Oracle transaction pattern: one row is inserted before a savepoint, a second row is inserted after it, then ROLLBACK TO SAVEPOINT is executed, and the session ends with no COMMIT.

Why A and B are correct: ROLLBACK TO SAVEPOINT undoes only the work done after the savepoint - the first insert survives in the active (open) transaction. Since no COMMIT is ever issued, the transaction remains open and uncommitted, making "No transaction commits" (A) true and "One row is inserted into band" (B) true simultaneously.

Why the distractors are wrong:

• C (Two transactions commit): No COMMIT occurred at all, so zero transactions committed.
• D (No row inserted): Wrong because the first insert (before the savepoint) was not rolled back.
• E (The transaction is rolled back to the savepoint): This describes an intermediate step that did happen, but it is not a complete or final truth - the transaction remained open afterward with one pending row, so it's misleading as a standalone true statement.

Memory tip: Think of a savepoint as a bookmark, not a commit. ROLLBACK TO SAVEPOINT tears out pages after the bookmark but leaves the book open - you still need a COMMIT to "publish" what remains.

No community discussion yet for this question.