053第423题

423.Which of the following describes how a distributed resumable transaction behaves?

A. The resumable setting on the initiating session determines the resumable conditions for the entire
distributed transaction.
B. The resumable setting for the initiating instance determines the resumable conditions for the entire
distributed transaction.
C. The resumable setting on the initiating session controls only that part of the transaction that occurs
within the local instance; remote resumable settings determine the behavior of the distributed parts of the
transaction.
D. None of the above.
Answer: C

In a distributed environment, if a user enables or disables resumable space allocation, or a DBA alters the RESUMABLE_TIMEOUT initialization parameter, then the local instance is affected. RESUMABLE cannot be enabled remotely. In a distributed transaction, sessions on remote instances are suspended only if the remote instance has already enabled RESUMABLE on the instance or sessions at its site.