CIW
1D0-541 · Question #113
Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 ) Primary Key Student_Number HOUSING( Housing_ID: integer NOT…
The correct answer is D. Modifications to STUDENT(Student_Number) are automatically reflected in changes to. See the full explanation below for the reasoning.
Question
Consider the following relation definitions:
STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 ) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 ) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION ON UPDATE CASCADE What are the referential constraints for the relations defined in these relation definitions?
Options
- AThere is no relationship between changes in STUDENT(Student_Number) and
- BWhen STUDENT(Student_Number) is changed or deleted, this modification or deletion will
- CModifications to HOUSING(Student_Number) are automatically reflected in changes to
- DModifications to STUDENT(Student_Number) are automatically reflected in changes to
How the community answered
(18 responses)- A6% (1)
- B6% (1)
- C11% (2)
- D78% (14)
Community Discussion
No community discussion yet for this question.