Q:

What does the following query find?

mhmadesk

Save to bookmark

|

2022-07-08

|

481

Medium

0

What does the following query find?

(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'red')
MINUS
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'green')

Find the sailor IDs of all sailors who have reserved red boats but not green boats
Find the sailor IDs of at least one sailor who have reserved red boats but not green boats
Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats
None of These

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

(a).Find the sailor IDs of all sailors who have reserved red boats but not green boats

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)