Question #1
Verified Q&A
Consider the following relations shown in the exhibit. Which of the following SQL statements would<br />
return the Customers2 relation from the Customers relation?<br />
<br />
<img src="https://examsqa.com/storage/question-images/ciw-v5-database-design-specialist-1d0-541_page_1_Im2.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" />
return the Customers2 relation from the Customers relation?<br />
<br />
<img src="https://examsqa.com/storage/question-images/ciw-v5-database-design-specialist-1d0-541_page_1_Im2.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" />
A
SELECT *<br />
FROM Customers<br />
WHERE Satisfaction_Rate <= 80<br />
OR Satisfaction_Rate >= 90;
B
SELECT *<br />
FROM Customers<br />
WHERE Satisfaction_Rate<br />
BETWEEN (80, 90);
C
SELECT *<br />
FROM Customers<br />
WHERE Satisfaction_Rate >= 80<br />
AND Satisfaction_Rate <= 89;
D
SELECT *<br />
FROM Customers<br />
WHERE Satisfaction_Rate IN (80 AND 90);
Correct Answer:
SELECT *<br />
FROM Customers<br />
WHERE Satisfaction_Rate >= 80<br />
AND Satisfaction_Rate <= 89;
