423rd questions, 053423

423rd questions, 053423
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
Transaction.
D. None of the above.
Answer:C

In a distributed environment, If a user enables or disables resumable space allocation, or a DBA altersRESUMABLE_TIMEOUTInitialization parameter, then the local instance is affected.RESUMABLECannot be enabled remotely. In a distributed transaction, sessions on remote instances are suincluded only if the remote instance has already enabledRESUMABLEOn the instance or sessions at its site.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.