CIW 1D0-541 - CIW v5 Database Design Specialist Exam
Page: 2 / 25
Total 124 questions
Question #6 (Topic: Single Topic)
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two
relations with the widest variety of Structured Query Language dialects?
relations with the widest variety of Structured Query Language dialects?
A. SELECT * FROM Dept1_Parts EXCEPT(SELECT PartJD FROM Dept2_Parts);
B. SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
C. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
D. SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (SELECT Part_ID FROM Dept2_Parts);
Answer: D
Question #7 (Topic: Single Topic)
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?
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));
Answer: D
Question #8 (Topic: Single Topic)
Which term describes one or more database operations that are executed as a single unit?
A. Update
B. Transaction
C. Encapsulation
D. Operational group
Answer: B
Question #9 (Topic: Single Topic)
Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes
the diagram shown in the exhibit?
the diagram shown in the exhibit?
A. Information Engineering (IE) data model
B. Corporate data model
C. Database requirements model
D. ERD model
Answer: B
Question #10 (Topic: Single Topic)
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?
A. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;
B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);
C. SELECT *FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);
Answer: C
