Explain the difference between each of the transaction models with respect to abort, commit, rollback, and isolation in the following cases:
a. A sequence of savepoints in a transaction and a chained transaction
b. A sequence of savepoints in a transaction and a nested transaction consisting of
subtransactions that are executed serially
c. A sequence of savepoints in a transaction and a sequence of transactions linked by
a recoverable queue
d. A sequence of chained transactions and a nested transaction consisting of
subtransactions that are scheduled serially
e. A sequence of chained transactions and a sequence of transactions linked by a
recoverable queue
f. A sequence of transactions linked by a recoverable queue and a nested transaction consisting of subtransactions that are executed serially
g. A nested transaction consisting of a set of concurrently executing siblings and a set of concurrently executing peer-related subtransactions of a distributed transaction
h. A nested transaction consisting of subtransactions that execute serially and a
multilevel transaction
i. A nested transaction consisting of subtransactions that execute serially and a
transaction using declarative demarcation consisting of modules specified with
RequiresNew
a. The transaction is durable at end of the chain and not at a savepoint.
b. Rolling back to a savepoint is similar to a subtransaction of a nested transaction
aborting, but if the savepoint transaction aborts, the entire transaction aborts.
c. The sequence of recoverable queue transactions is not atomic, the savepoint
transaction is atomic.
d. The chained transactions are durable at chain points, but individual nested
subtransactions are not durable.
e. They are very similar, except that the recoverable queue transactions might take
place at different times.
f. The recoverable queue transactions are not serializable and are durable at the end of each transactions. The nested transactions are serializable and not durable until the the top-level transaction commits.
g. In the nested transactions, a sibling can abort without the entire transaction
aborting. In the peer related transactions, individual transactions can communicate
with each other and any individual transaction can start the commit procedure.
h. The ACID properties are the same for both, but the multilevel transaction executes more efficiently because it can give up its locks earlier. Also a subtransaction of a nexted transaction can abort without aborting the entire transaction, while a multilevel transaction does not have this property.
i. In the nested transaction, the subtransactions can separately abort, but the overall transaction is ACID. In the declarative demarcation example, each module is
separately ACID and the top-most transaction (with the modules deleted) is ACID.
You might also like to view...
What do the words Compatibility Mode in the title bar tell you about the document you have opened?
A) The file was most likely created in the newest version of Word. B) You cannot save the document as a Word 2013 file. C) The file is saved in Rich Text Format. D) The file was most likely created in an earlier version of Word, which means that some Word 2013 features might not be available or viewable.
COGNITIVE ASSESSMENT A host in a network performs which of the following tasks?
A. ensures satellite communications are functional B. exclusively monitors wireless networks to search for data transmission errors C. routes transmissions over a network to guarantee data reaches its intended destination D. provides services and connections to other computers on the network
A Windows computer on your network is having issues resolving queries for a specific domain, but not other domains. Other computers on the same network resolve the name just fine. What command can you issue that might fix the problem?
a. ipconfig /renew b. ipconfig /release c. ipconfig /flushdns d. ipconfig /refresh
When there are multiple background processes executing in the shell, the jobs command indicates the most recent one with which symbol?
A. - B. / C. + D. *