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.