CIW Exam 1D0-541 Topic 3 Question 69 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 69
Topic #: 3

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

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

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

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

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

Show Suggested Answer

Suggested Answer: D

by Weldon at Apr 21, 2023, 11:58 AM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Doretha

27 days ago

Option A looks like it might work, but it would also include customers with a satisfaction rate of 90 or above, which is not what we want.

upvoted 0 times

...

Wenona

1 months ago

Haha, option D looks like it's trying to use a date range for a numeric column. Nice try, but no cigar!

upvoted 0 times

Ulysses

8 days ago

User 1: Yeah, option D doesn't make sense for a numeric column.

upvoted 0 times

...

Nelida

1 months ago

I'm not sure about option B, as it's trying to filter for a single value of 80 AND 90, which doesn't make sense.

upvoted 0 times

2 months ago

I think the correct answer is C.

upvoted 0 times

...