ITPEC IP October 2020 Question 28
ITPEC IP October 2020 — Question 28 of 100
Relational database records are associated by matching values in corresponding fields, commonly a primary key and a foreign key. A join uses these values to combine related rows; their physical row positions do not determine the relationship.
Answer (b)
Why not others:
- row ordering has no inherent relational meaning
- parentage pointers characterize navigational structures rather than the relational model
- hashing can locate records efficiently but does not define logical relationships between them
Key rule: Relational links are value-based, which keeps logical relationships independent of physical storage order.
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.