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

25 days 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

Eun

7 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

...

I think the answer is A.

upvoted 0 times

...