adplus-dvertising

Welcome to the SQL MCQs Page

Dive deep into the fascinating world of SQL with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of SQL, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of SQL, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

frame-decoration

Check out the MCQs below to embark on an enriching journey through SQL. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of SQL. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

SQL MCQs | Page 24 of 38

Explore more Topics under DBMS

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

a.

SELECT city, temperature, humidity, country FROM location;

b.

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

c.

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

d.

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

Discuss
Answer: (c).SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
Q232.
Find the name of cities with all entries whose temperature is in the range of 71 and 89

a.

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

b.

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

c.

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

d.

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

Discuss
Answer: (d).SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
Q233.
Which of the following query finds the names of the sailors who have reserved at least one boat?

a.

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

b.

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

c.

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

d.

None of These

Discuss
Answer: (a).SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
Q234.
Which of the following query finds colors of boats reserved by "Dustin"?

a.

SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

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;

c.

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

d.

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

Discuss
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;
Q235.
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')

a.

Find the sailor IDs of all sailors who have reserved red boats but not green boats

b.

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

c.

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

d.

None of These

Discuss
Answer: (a).Find the sailor IDs of all sailors who have reserved red boats but not green boats
Q236.
Which of the following query finds the name of the sailors who have reserved at least two boats?

a.

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

b.

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

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

d.

All of these

Discuss
Answer: (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
Q237.
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

a.

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

b.

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

c.

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

d.

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

Discuss
Answer: (d).SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
Q238.
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

a.

Hi

b.

FLASE

c.

TRUE

d.

Nothing

Discuss
Answer: (d).Nothing
Q239.
If a query involves NOT, AND, OR with no parenthesis

a.

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

b.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

c.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

d.

The order of occurrence determines the order of evaluation.

Discuss
Answer: (a).NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
Q240.
Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

a.

less than 10 rows

b.

more than 10 rows

c.

exactly 10 rows

d.

None of these

Discuss
Answer: (c).exactly 10 rows
Page 24 of 38

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...