CIW
1D0-541 · Question #113
1D0-541 Question #113: Real Exam Question with Answer & Explanation
Sign in or unlock 1D0-541 to reveal the answer and full explanation for question #113. The question stem and answer options stay visible for context.
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
Unlock 1D0-541 to see the answer
You've previewed enough free 1D0-541 questions. Unlock 1D0-541 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.