Answer first before explanation please

Which of the following scenarios reflect the atomicity
property?

A) 1. A transaction has completed executing.
2: The changes are saved to volatile memory.
3. The changes are then saved to non-volatile
memory.

B) 1. The product quantity starts at 200.
2. Transaction 1 runs to read the quantity of the
product to be updated.
3. Transaction 2 attempts to read the quantity of
the same product.
4. Transaction 2 has to wait until transaction 1 is
complete.
5. Transaction 1 updates the product quantity to
reduce it by 100.
6. Transaction 2 is now able to read the quantity
to be updated.
7. Transaction 2 updates the product quantity to
reduce it by 5.
8. The product quantity ends at 95.

C) 1. The newsletter column can only accept Y or N
as options.
2. The user tries to attempt to enter in Maybe.
3. The transaction is denied.

D) 1. A transaction has two SQL requests.
2. Both successfully complete.
3. The data is then committed.

Respuesta :

D) Transaction has two SQL requests, both successfully complete, the data is then committed.

Explanation: Atomicity requires that all SQL requests in a transaction should be fully completed and if not, the entire transaction should be aborted. The transaction should be viewed as a single logical unit of work that is indivisible.