What happens to a deferred transaction if the filegroup that it is holding it up becomes defunct?
A. The transaction is unaffected. The deferred status remains because it was not properly resolved.
B. The transaction is moved out of the deferred state.
C. The database becomes suspect.
D. The filegroup cannot be moved into the defunct state until the transaction is resolved.
Answer:B
What happens to a deferred transaction if the filegroup that it is holding it up becomes defunct?
A. The transaction is unaffected. The deferred status remains because it was not properly resolved. B. The transaction is moved out of the deferred state. C. The database becomes suspect. D. The filegroup cannot be moved into the defunct state until the transaction is resolved.