CIW
1D0-541 · Question #114
Consider the following relation definition: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING( Housing_ID…
The correct answer is C. Referential integrity. See the full explanation below for the reasoning.
Question
Consider the following relation definition:
STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO CHECK ON UPDATE Which integrity constraint is violated in this relation definition?
Options
- AEntity integrity
- BDomain constraint
- CReferential integrity
- DEnterprise constraint
How the community answered
(44 responses)- A14% (6)
- B5% (2)
- C75% (33)
- D7% (3)
Community Discussion
No community discussion yet for this question.