Dividing an application program into several transactions usually:
A) Improves constraint checking
B) Reduces the possibility of deadlocks
C) Increases potential waiting by other transactions
D) All of the above

Question

Quizplus · Accepted Answer

Dividing an application program into several transactions reduces the possibility of deadlocks, which can occur when multiple transactions are competing for the same resources and end up waiting indefinitely for each other to release them. However, it may increase potential waiting by other transactions if one transaction holds a resource needed by another transaction. Constraint checking may or may not be improved by dividing the program into transactions, depending on the specific constraints involved.

Dividing an Application Program into Several Transactions Usually