ITPEC IP April 2020 Question 26
ITPEC IP April 2020 — Question 26 of 100
Two employees live in a different prefecture from their departments. H002 lives in Kanagawa while G01 is in Tokyo, and H003 lives in Mie while G03 is in Aichi. H001, H004, H005, and H006 match their department prefectures.
Answer (b)
Why not others:
- joining by Department_code is necessary before comparing each employee's prefecture with the corresponding department row
- the comparison produces exactly two mismatches, not one, three, or four
Key rule: Join related tables on their common key, then apply the selection condition to columns from the matched rows.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.