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.
A. COMMIT TRANSACTION
B. SAVE TRANSACTION
C. ROLLBACK TRANSACTION
D. None of the mentioned
Answer:A
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.
A. COMMIT TRANSACTION B. SAVE TRANSACTION C. ROLLBACK TRANSACTION D. None of the mentioned
Explanation: If @@TRANCOUNT is greater than 1, COMMIT TRANSACTION decrements @@TRANCOUNT only by 1 and the transaction stays active. Sanfoundry Global Education & Learning Series – SQL Server.