Explanation:If there is an error occuring within these statements individually, SQL Server will roll back the complete statement. 9. ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement for ___________ transactions.
A. Simple
B. Nested
C. Distributed
D. None of the mentioned
Answer:A
Explanation:If there is an error occuring within these statements individually, SQL Server will roll back the complete statement. 9. ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement for ___________ transactions.
A. Simple B. Nested C. Distributed D. None of the mentioned
Explanation:When nesting transactions, ROLLBACK WORK decrements the @@TRANCOUNT system function to 0. 10. Which of the following condition will ignore the request to enable delayed durability ?