ITPEC IP April 2021 Question 27
ITPEC IP April 2021 — Question 27 of 100
A single table can define multiple foreign keys. Each foreign key establishes a referential relationship from one or more columns in the table to a candidate or primary key in another table, and a table may participate in several such relationships.
Answer (c)
Why not others:
- uniqueness is not an inherent property of a foreign key
- duplicate foreign-key values are allowed, as many rows may reference the same parent row
- a foreign key can be composite and therefore consist of multiple columns
Key rule: Foreign keys enforce referential integrity, not uniqueness, and tables may have multiple 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.