MCQs
Total Questions : 109
| Page 5 of 11 pages
Answer: Option A. -> SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
Answer: Option C. -> SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
Answer: Option B. -> SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
Answer: Option C. -> SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
Answer: Option D. -> SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
Answer: Option A. -> SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
Answer: Option 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;
Answer: Option A. -> Find the sailor IDs of all sailors who have reserved red boats but not green boats
Answer: Option C. -> SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid r2.bid
Answer: Option D. -> SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103