Explanation:BEGIN TRANSACTION increments @@TRANCOUNT by 1. 6. ____________ rolls back a user-specified transaction to the beginning of the transaction.
A. ROLLBACK
B. ROLLBACK WORK
C. SAVE TRANSACTION
D. COMMIT
Answer:A
Explanation:BEGIN TRANSACTION increments @@TRANCOUNT by 1. 6. ____________ rolls back a user-specified transaction to the beginning of the transaction.
A. ROLLBACK B. ROLLBACK WORK C. SAVE TRANSACTION D. COMMIT
Explanation:When nesting transactions, ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement. 7. Which of the following is valid syntax for SAVE TRANSACTION with all the optional parameters ?