nerdexam
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)
  • A
    14% (8)
  • B
    3% (2)
  • C
    74% (43)
  • D
    9% (5)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice