CIW 1D0-541 Exam - Topic 3 Question 124 Discussion

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

Question #: 124
Topic #: 3

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID,

Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and

Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which

SQL statement best implements the RESIDENT relation shown in this diagram?

ACREATE TABLE RESIDENT (
R_ID INTEGER NULL PRIMARY KEY,
Room_Num FLOAT,
Res_Name VARCHAR,
Building_ID INTEGER NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

BCREATE TABLE RESIDENT (
R_ID INTEGER NOT NULL PRIMARY KEY,
Room_Num BINARY,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

CCREATE TABLE RESIDENT (
R_ID INTEGER NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL);

DCREATE TABLE RESIDENT (
R_ID INTEGER NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

Show Suggested Answer

Suggested Answer: D

by Mitsue at Apr 11, 2026, 10:53 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Kristal

7 hours ago

I feel like I’ve seen a similar question before, and I think the foreign key is important for linking to the BUILDING table.

upvoted 0 times

...

Fannie

5 days ago

I remember we discussed that the primary key should be NOT NULL, so I think options A and B are not correct.

upvoted 0 times

...