Q:

Which of the following query finds colors of boats reserved by \"Dustin\"?

belongs to collection: DBMS - SQL MCQ

0

Which of the following query finds colors of boats reserved by "Dustin"?


  1. SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = \'Dustin\' AND s.sid = b.sid
  2. SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = \'Dustin\' AND s.sid = r.sid AND r.bid = b.bid;
  3. SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = \'Dustin\' AND s.sid = r.sid
  4. SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = \'Dustin\' AND r.bid = b.bid

All Answers

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

 (b).SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;

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

total answers (1)

DBMS - SQL MCQ

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now
What does the following query find?... >>
<< Which of the following query finds the names of th...