Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. CIW
  4. CIW Web Development Series
  5. 1D0-541 Discussions
  6. 1D0-541 Exam Topic 3 Question 20 Discussion
 CIW Discussions
Exam 1D0-541 All Questions
Exam 1D0-541 All Questions

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

Go to Exam

CIW Web Development Series 1D0-541 Question # 20 Topic 3 Discussion

1D0-541 Exam Topic 3 Question 20 Discussion:
Question #: 20
Topic #: 3

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name and Res_Name are represented by variable-length strings with a maximum of 20 characters. Location can be up to 50 characters long, and no building has more than 600 rooms. Which SQL statement best implements the BUILDING relation shown in this diagram?

1D0-541 Question 20
A.

CREATE TABLE BUILDING (

Building_ID NOT NULL PRIMARY KEY,

Bldg_Name, Location, Room_Count);

B.

CREATE TABLE BUILDING ( Building_ID NOT NULL PRIMARY

KEY, Bldg_Name, Location, Room_Count, FOREIGN KEY

Building_ID REFERENCES BUILDING (Building_ID));

C.

CREATE TABLE BUILDING (Building_ID

INTEGER NOT NULL PRIMARY KEY,Bldg_Name

VARCHAR (20), Location VARCHAR (50),

D.

CREATE TABLE BUILDING (Building_ID

INTEGER NOT NULL PRIMARY KEY, Bldg_Name

VARCHAR (20), Location VARCHAR (50),

Room_Count INTEGER CHECK (Room_Count >

Room_Count INTEGER CHECK (

-1 And Room_Count < 601));

Room_Count > -1 Or Room_Count < 601));

Get Premium 1D0-541 Questions
Actual exam question for CIW 1D0-541 exam by Kai7990 at May 1, 2026, 5:15:16 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit