Question 370
A report query must find invoice ids that exist in ledger A but not in ledger B. Which test result satisfies the scenario?
Explanation
Correct Answer
This directly verifies the intended outcome: Anti-joins express set difference between relations. The accepted result is: The result contains only A invoices with no match in B.
Incorrect Answers
Stacking doesn't isolate missing ids.
Produces unrelated invoice pairs.
Returns shared ids, not missing ones.