Software Development Fundamentals — Question 44

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.

Answer options

• A. No change is needed
• B. succeeds or fails as a unit
• C. finishes as quickly as possible
• D. can be completed concurrently with other transactions

Correct answer: B

Explanation

The correct answer is B because transactions ensure that all operations within them either complete successfully or fail as a single unit, thus maintaining data integrity. The statement that the update cannot fail is misleading; a transaction can fail, but it will roll back to ensure no partial updates occur. The other options do not accurately represent the primary benefit of transactions in relation to multiple table updates.