You are not logged in.

#1 2015-09-18 06:25:27

husnain
User RankUser RankUser RankUser RankUser RankUser Rank
Administrator
From: Chichawatni,Pakistan
Registered: 2014-10-03
Posts: 8,129
Website

SQL Quiz Question.

Database Quizzes SQL

Question:
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')

Option A):
Find the sailor IDs of all sailors who have reserved red boats but not green boats
Option B):
Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats
Option C):
Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Correct Answer is Option A):
Find the sailor IDs of all sailors who have reserved red boats but not green boats


You cannot discover the new oceans unless you have the courage to lose the sight of the shore.

2015-09-18 06:25:27

Advertisement
Ads By Google

Re: SQL Quiz Question.



Board footer