Multiple choice

How can we terminate a transaction, if the transaction is initiated by BEGIN TRANSACTION?

  1. COMMIT TRANSACTION

  2. ROLL BACK TRANSACTION

  3. (1) or (2)

  4. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To SAVE and EXIT from the transaction, we should write COMMIT, or if we have made savepoint, then we have revert back then, make SAVEPOINT. So,  we can make either COMMIT or SAVEPOINT according to the query.

Keep practicing — related questions