CIW Exam 1D0-541 Topic 4 Question 106 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 106
Topic #: 4

[All 1D0-541 Questions]

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?

AEntity integrity

BDomain constraint

CReferential integrity

DEnterprise constraint

Show Suggested Answer

Suggested Answer: C

by Alesia at Jan 22, 2025, 04:03 PM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephen

13 days ago

Hmm, this one's tricky. I think the answer is C) Referential integrity, since the HOUSING relation has a foreign key that references the STUDENT relation, but the ON DELETE constraint is set to NO CHECK, which could lead to dangling references.

upvoted 0 times

...

Carmelina

13 days ago

I believe the correct answer is C) Referential integrity because the foreign key reference is not properly set up.

upvoted 0 times

...

Lura

15 days ago

I agree with Catarina, the foreign key constraint is not properly defined.

upvoted 0 times

...

Catarina

17 days ago

I think the integrity constraint violated is referential integrity.

upvoted 0 times

...