Examice

Exam 1D0-541 All QuestionsBrowse all questions from this exam

Question 9

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

SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;

SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);

SELECT *FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;

SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Correct Answer: C

The correct SQL statement to return the Customers2 relation from the Customers relation is: SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89. The Customers2 relation includes records where the Satisfaction_Rate is between 80 and 89 inclusive (85 and 81 in this case). The options that involve satisfaction rates of exactly 80 or 90, or using the BETWEEN syntax without proper boundaries, are incorrect.

Discussion

dayogreatsOption: C

c is the answer