Computer scienceFundamentalsSQL and DatabasesDB TheoryCommon DB topics

Introduction to transactions

Money transfer

Report a typo

Suppose you're making a transaction in which you need to transfer 100 dollars from account "X" (source account) to account "Y" (destination account). Assume that the balances of these accounts are 2000 dollars and 1000 dollars respectively, so operations can be executed. Place the following actions, which you need to take, in the correct order.

Put the items in the correct order

reading item X

begin transaction

writing item Y

Y=Y+100

commit transaction

X=X-100

reading item Y

writing item X

___

Create a free account to access the full topic