Question 190
A shipping table and currency-rate table both require matching country_code AND event_date to avoid historical rate mistakes. Which result should determine whether the change is accepted?
Explanation
Correct Answer
This outcome directly verifies the scenario's required behavior: composite join keys prevent unrelated time-period matches.
Incorrect Answers
A Cartesian product does not select valid rate pairs.
One shipment may match multiple exchange-rate dates.
Rates from other countries may attach to shipments.