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.

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

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Normalization

08

Storage and File Structures

09

Indexing and Hashing

10

Transactions

11

Concurrency Control

12

Recovery System

13

Distributed Databases

14

Data Warehousing and Data Mining

15

RDBMS

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q231.

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

SELECT city, temperature, humidity, country FROM location;

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;

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

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

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

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

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?

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

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

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

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"?

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

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, 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')

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

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

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?

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

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

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"?

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

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

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

FLASE

TRUE

Nothing

Discuss

Answer: (d).Nothing

Q239.

If a query involves NOT, AND, OR with no parenthesis

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

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

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

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

less than 10 rows

more than 10 rows

exactly 10 rows

None of these

Discuss

Answer: (c).exactly 10 rows

Page 24 of 38

Welcome to the SQL MCQs Page

SQL MCQs | Page 24 of 38

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

Distributed Databases

Data Warehousing and Data Mining

RDBMS

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

Embedded Systems

Object Oriented Programming Using C++

PHP

IT Fundamentals

Computer Graphics

MATLAB

Formal Languages and Automata Theory

Hadoop

C# programming