CIW
1D0-441 · Question #21
1D0-441 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock 1D0-441 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
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 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?
Exhibit
Options
- ACREATE TABLE BUILDING (
- BCREATE TABLE BUILDING (
- CCREATE DOMAIN ID AS INTEGER;
- DCREATE TABLE BUILDING (
Unlock 1D0-441 to see the answer
You've previewed enough free 1D0-441 questions. Unlock 1D0-441 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.