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

Raina

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

...