Microsoft
98-361 · Question #90
This question requires that you evaluate the underlined text to determine if it is correct. The benefit of using a transaction when updating multiple tables is that the update cannot fail. Select…
The correct answer is B. succeeds or fails as a unit. The benefit of using a transaction when updating multiple tables is that the update succeeds or fails as a unit.
Understanding Databases
Question
This question requires that you evaluate the underlined text to determine if it is correct. The benefit of using a transaction when updating multiple tables is that the update cannot fail. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed" if the underlined text makes the statement correct.
Options
- ANo change is needed
- Bsucceeds or fails as a unit
- Cfinishes as quickly as possible
- Dcan be completed concurrently with other transactions
How the community answered
(34 responses)- A6% (2)
- B76% (26)
- C3% (1)
- D15% (5)
Explanation
The benefit of using a transaction when updating multiple tables is that the update succeeds or fails as a unit.
Topics
#transactions#atomicity#ACID properties#database integrity
Community Discussion
No community discussion yet for this question.