Explanation:Generally we don’t include Select statement in a transaction. 9. _________ permissions default to any valid user.
A. ROLLBACK WORK
B. ROLLBACK
C. COMMIT
D. None of the mentioned
Answer:A
Explanation:Generally we don’t include Select statement in a transaction. 9. _________ permissions default to any valid user.
A. ROLLBACK WORK B. ROLLBACK C. COMMIT D. None of the mentioned
Explanation:When nesting transactions, ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement and decrements the @@TRANCOUNT system function to 0. 10.If @@TRANCOUNT is 1, ________ makes all data modifications performed since the start of the transaction a permanent part of the database.