Questions and answers for exam Preparation

MCQs

Total Questions : 126 | Page 11 of 13 pages

Question 101. Find the names of the countries whose condition is sunny.

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');
SELECT country FROM location WHERE condition = 'sunny';
SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

Discuss Question

Answer: Option D. -> SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

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

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid
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;
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid
SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

Discuss Question

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;

Question 103. Find the name of all cities with their temperature, humidity and countries.

SELECT weather.city, temperature, humidity, country FROM weather, location;
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;
SELECT city, temperature, humidity, country FROM location;

Discuss Question

Answer: Option B. -> SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

Question 104. Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

Discuss Question

Answer: Option B. -> SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

Question 105. Which of the following query finds the names of the sailors who have reserved at least one boat?

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
None of These
SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

Discuss Question

Answer: Option D. -> SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

Question 106. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

Hi
TRUE
FLASE
Nothing

Discuss Question

Answer: Option D. -> Nothing

Question 107. Which of the following is illegal?

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
None of these
SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
SELECT SYSDATE - SYSDATE FROM DUAL;

Discuss Question

Answer: Option B. -> None of these

Question 108. Which of the following query finds the total rating of the sailors who have reserved boat "103"?

c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;
SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

Discuss Question

Answer: Option B. -> SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

Question 109. What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')

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
Find the sailor IDs of all sailors who have reserved red boats but not green boats
None of These

Discuss Question

Answer: Option C. -> Find the sailor IDs of all sailors who have reserved red boats but not green boats

Question 110. Which of the following query finds the name of the sailors who have reserved at least two boats?

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid
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
All of these
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

Discuss Question

Answer: Option D. -> 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