You are not logged in.
Pages:: 1
#1 2015-09-18 06:24:48
SQL Quiz Question.
Database Quizzes SQL
Question:
Which of the following query finds colors of boats reserved by "Dustin"?
Option A):
SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid
Option B):
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid
Option C):
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;
Correct Answer is Option C):
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;
You cannot discover the new oceans unless you have the courage to lose the sight of the shore.
Offline
2015-09-18 06:24:48
- Advertisement
- Ads By Google
Re: SQL Quiz Question.
\n
Pages:: 1