CIW Exam 1D0-541 Topic 6 Question 102 Discussion

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

Question #: 102
Topic #: 6

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: B

by Hildegarde at Oct 20, 2024, 07:27 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Melina

1 months ago

I'm just glad they didn't ask about the BUILDING table. That would have been a real foundation-al problem!

upvoted 0 times

Emilio

13 days ago

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

upvoted 0 times

...

Layla

14 days ago

B) CREATE 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));

upvoted 0 times

...

Eun

27 days ago

A) CREATE 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));

upvoted 0 times

...

Melvin

2 months ago

Option A is incorrect because the Room_Num column should be an integer, not a float.

upvoted 0 times

Ardella

21 days ago

Yes, option D also seems correct with Room_Num as an integer.

upvoted 0 times

...

Hildegarde

1 months ago

But option C also has Room_Num as an integer and looks good.

upvoted 0 times

...

Basilia

2 months ago

I agree, option B looks like the correct choice with Room_Num as BINARY.

upvoted 0 times

...

Corazon

2 months ago

I think option A is incorrect because the Room_Num column should be an integer, not a float.

upvoted 0 times

...

Ty

2 months ago

Option C is missing the foreign key constraint to the BUILDING table, which is necessary to maintain data integrity.

upvoted 0 times

...

Odelia

2 months ago

Option B is wrong because the Room_Num column should be an integer, not a binary data type.

upvoted 0 times

Portia

1 months ago

I agree, option B is incorrect because Room_Num should be an integer.

upvoted 0 times

...

Hildegarde

2 months ago

I think option A is the correct one.

upvoted 0 times

...

Raina

2 months ago

The correct answer is option D. It correctly defines the RESIDENT table with the appropriate data types and the necessary foreign key constraint to link the Building_ID to the BUILDING table.

upvoted 0 times

...