CIW v5 Database Design Specialist 1D0-541 Question # 9 Topic 1 Discussion

CIW v5 Database Design Specialist 1D0-541 Question # 9 Topic 1 Discussion

1D0-541 Exam Topic 1 Question 9 Discussion:
Question #: 9
Topic #: 1

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

1D0-541 Question 9


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);


Get Premium 1D0-541 Questions

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.