for sql , please answer question :

(a)

Pick : Atomic Consistent Durable Isolated

A transaction deletes an account with primary key of 5. A subscription references that primary key of 5 as a foreign key.

(b)

Pick : Atomic Consistent Durable Isolated

Two transactions run in parallel to set an account's balance to different values.

(c)

Pick: Atomic Consistent Durable Isolated

A transaction withdraws $25 from each account. However, a system failure caused withdrawals for only half of the accounts to be written to the database.

(d)

Pick: Atomic Consistent Durable Isolated

A transaction updates a subscription's EndDate. The update is written in the database, but due to a drive failure, the information is permanently lost.