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 23 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

Q221.

Which of the following command makes the updates performed by the transaction permanent in the database?

ROLLBACK

COMMIT

TRUNCATE

DELETE

Discuss

Answer: (b).COMMIT

Q222.

Which command undo all the updates performed by the SQL in the transaction?

ROLLBACK

COMMIT

TRUNCATE

DELETE

Discuss

Answer: (a).ROLLBACK

Q223.

Find all the cities whose humidity is 89

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather;

Discuss

Answer: (b).SELECT city FROM weather WHERE humidity = 89;

Q224.

Find the temperature in increasing order of all cities

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY city;

Discuss

Answer: (c).SELECT city, temperature FROM weather ORDER BY temperature;

Q225.

What is the meaning of LIKE '%0%0%'

Feature begins with two 0's

Feature ends with two 0's

Feature has more than two 0's

Feature has two 0's in it, at any position

Discuss

Answer: (d).Feature has two 0's in it, at any position

Q226.

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

Discuss

Answer: (a).SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

Q227.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70F.

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

Discuss

Answer: (c).SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

Q228.

Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > 'Paris' temperature

Discuss

Answer: (a).SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')

Q229.

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

Discuss

Answer: (c).SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

Q230.

Find the names of the countries whose condition is sunny.

SELECT country FROM location WHERE condition = 'sunny';

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = 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');

Discuss

Answer: (b).SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

Page 23 of 38

Welcome to the SQL MCQs Page

SQL MCQs | Page 23 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

MySQL Database

Computer Architecture

JavaScript

CSS

Operating System

Data Warehousing and OLAP

R Programming

CompTIA PenTest+ Certification Exam PT0 002

Data Structures and Algorithms