Katie goes to the bank and withdraws $6,500 from her $10,000 checking account.Database A receives the request and records a new checking account balance of $3,500, but database B does not get updated. It still shows a balance of $10,000.Then, Katie makes a request to check the balance on her checking account, but that request gets sent to database B, which returns in accurate information because the withdrawal transaction was never carried over to this database. Which of the following best describes what should be enabled to make sure that this type of situation does not take place?
A.
Polyinstantiation
B.
Two-phase commit
C.
On-line transaction processing
D.
Rolebacks
Explanation:
The main goal of OLTP is to ensure that transactions happen properly or they don’t happen at all. Transaction processing usually means that individual indivisible operations are taking place independently. If one of the operations fails, the rest of the operations needs to be rolled back to ensure that only accurate data is entered into the database.