CIW
1D0-441 · Question #46
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
(58 responses)- A14% (8)
- B3% (2)
- C74% (43)
- D9% (5)
Community Discussion
No community discussion yet for this question.