ITPEC IP April 2026 Question 27
ITPEC IP April 2026 — Question 27 of 100
A table can define multiple foreign keys — each can reference a key in the same or a different parent table.
For example, an Orders table can contain both customer_id referencing Customers and product_id referencing Products. Foreign-key values may repeat because many child rows can reference the same parent, and a foreign key may also be composite.
Answer (c)
Why not others: (a) confuses referential integrity with uniqueness; (b) wrongly forbids repeated references; (d) wrongly excludes composite foreign keys made from multiple columns.
Key rule: A foreign key enforces that referenced parent values exist; it need not be unique, and tables may have several simple or composite foreign keys.
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.