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 ?
A. DELAYED_DURABILITY = FORCED
B. DELAYED_DURABILITY = 0
C. DELAYED_DURABILITY = IGNORED
D. DELAYED_DURABILITY = NULL
Answer:A
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 ?
A. DELAYED_DURABILITY = FORCED B. DELAYED_DURABILITY = 0 C. DELAYED_DURABILITY = IGNORED D. DELAYED_DURABILITY = NULL
Explanation:The request is ignored if the database has been altered with DELAYED_DURABILITY = DISABLED or DELAYED_DURABILITY = FORCED. Sanfoundry Global Education & Learning Series – SQL Server.