easy5 pts · first answer countstransactionssql

Atomicity in a money transfer

A transfer debits account A and then credits account B inside one database transaction. The server crashes after the debit but before COMMIT. What is the state after restart?

A.The debit is saved and the credit is lostB.Neither change is saved, because the uncommitted transaction is rolled backC.The database replays the debit and then finishes the credit automatically from its write-ahead log on restartD.The debit is saved only if the table has a primary key

← What a foreign key enforces Browser blocks a call that curl allows →