Transactions should be used to: (Choose 2)

The correct answer is A. Prevent errors in cases of a power outage or a failure in the SQL connection C. Ensure that either all statements are performed properly, or that none of them are. See the full explanation below for the reasoning.

Databases & SQL

Question

Transactions should be used to: (Choose 2)

Options

APrevent errors in cases of a power outage or a failure in the SQL connection
BEnsure that the data is properly formatted
CEnsure that either all statements are performed properly, or that none of them are.
DRecover from user errors

How the community answered

(24 responses)

A
71% (17)
B
13% (3)
D
17% (4)

Topics

#transactions#atomicity#data integrity#error recovery

Community Discussion

No community discussion yet for this question.

Full 200-710 Practice