Free CIW 1D0-541 Exam Questions

Become CIW Certified with updated 1D0-541 exam questions and correct answers

Page: 1 / 25

Total 125 Questions | Updated On: Jul 30, 2025

Add To Cart

Question 1

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

A : eate intermediate entities

B : eate a logical data model.

C : olve many-to-many relationships

D : entify and resolve complex relationships.

Answer: B

Question 2

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

A : ERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);

B : ERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);

C : ERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

D : ERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

Answer: D

Question 3

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

A : LECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta

B : LECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta

C : LECT * FROM Customers WHERE Satisfaction_Rate >= 80;

D : LECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Answer: A

Question 4

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A : m

B : n

C : 1:1

D : 1:n

Answer: B

Question 5

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

A :

B :

C :

D :

Answer: D

Page: 1 / 25

Total 125 Questions | Updated On: Jul 30, 2025

Add To Cart