ITPEC IP April 2021 Question 29
ITPEC IP April 2021 — Question 29 of 100
The union is R and the intersection is P. Union contains every distinct row appearing in either table: the five rows from A plus P020 from B, exactly as shown in R. Intersection contains only rows common to both A and B, namely P003 and P007, exactly as shown in P.
Answer (c)
Why not others:
- Q contains only the rows exclusive to A, so it is neither the union nor the intersection
- reversing P and R confuses common rows with all distinct rows
Key rule: UNION combines all distinct rows from both compatible tables; INTERSECTION keeps only rows present in both.
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.