Question: Select the ACID property violated in each example. ( a ) Pick A transaction updates all accounts with a BalanceAmount of NULL to 0 .

Select the ACID property violated in each example.(a)
Pick
A transaction updates all accounts with a BalanceAmount of NULL to 0. The updates are written in the database, but due to a drive failure, the information is permanently lost.(b)
Pick
A transaction deletes an account with primary key of 5. A subscription references that primary key of 5 as a foreign key.(c)
Pick
A transaction updates all accounts with a BalanceAmount of NULL to 0. Due to a system failure, updates for only half of the accounts are written to the database.(d)
Pick
Transaction 1 slowly updates account A's balance by a complex algorithm that reads the balance. Transaction 2 quickly withdraws 5 from account A's balance. Transaction 2 starts before 1 finishes.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!