Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. ____________ rolls back a user-specified transaction to the beginning of the transaction.
  2. A.
    ROLLBACK
    B.
    ROLLBACK WORK
    C.
    SAVE TRANSACTION
    D.
    COMMIT

    View Answer

    Workspace

    Answer : Option B

    Explanation :

    When nesting transactions, ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement.


Be The First To Comment