Question 320
A data architect recommends this approach: Roll back the uncommitted transaction rather than committing its partial changes. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Transaction rollback. Related uncommitted changes are undone to preserve transaction consistency.
Incorrect Answers
The other situation is better matched to Use a LEFT OUTER JOIN from customers to orders. Unmatched customers remain in the output with null columns for orders.
The other situation is better matched to Move attributes dependent on only part of the composite key to the correct entity table. Partial-key dependencies are reduced and updates become more consistent.
The other situation is better matched to Use UPDATE with a WHERE clause targeting the supplier key. Only the selected existing row's address fields are modified.