CIW
1D0-541 · Question #38
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…
The correct answer is D. CREATE TABLE RESIDENT (. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ACREATE TABLE RESIDENT (
- BCREATE TABLE RESIDENT (
- CCREATE TABLE RESIDENT (
- DCREATE TABLE RESIDENT (
How the community answered
(37 responses)- A3% (1)
- B14% (5)
- C5% (2)
- D78% (29)
Community Discussion
No community discussion yet for this question.