Exam 1D0-541 topic 1 question 7 discussion

Actual exam question from CIW's 1D0-541

Question #: 7
Topic #: 1

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?

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));
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));
C. CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL);
D. CREATE 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 dayogreats at Aug. 3, 2023, 12:43 p.m.

Comments

Submit Cancel

dayogreats

4 months, 3 weeks ago

Selected Answer: D

D has the most valid sql query

upvoted 1 times

...

Exam 1D0-541 All Questions

View all questions & answers for the 1D0-541 exam

Exam 1D0-541 topic 1 question 7 discussion

Comments

dayogreats

SY0-701