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

Q1.

The SQL database language includes statements for:

Database definition.

Database manipulation.

Database control.

All of the above.

Discuss

Answer: (d).All of the above.

Q2.

A command to remove a relation from an SQL database

Delete table table name

Drop table table name

Erase table table name

Alter table table name

Discuss

Answer: (b).Drop table table name

Q3.

Which SQL Query is use to remove a table and all its data from the database?

Create Table

Alter Table

Drop Table

None of these

Discuss

Answer: (c).Drop Table

Q4.

A type of query that is placed within a WHERE or HAVING clause of another query is called

Super query

Sub query

Master query

Multi-query

Discuss

Answer: (b).Sub query

Q5.

Aggregate functions are functions that take a ___________ as input and return a single value.

Collection of values

Single value

Aggregate value

Both a & b

Discuss

Answer: (a).Collection of values

Q6.

Select __________ from instructor where dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary ?

Mean(salary)

Avg(salary)

Sum(salary)

Count(salary)

Discuss

Answer: (b).Avg(salary)

Q7.

All aggregate functions except _____ ignore null values in their input collection.

Count(attribute)

Count(*)

Avg

Sum

Discuss

Answer: (b).Count(*)

Q8.

A Boolean data type that can take values true, false, and________ .

Null

Unknown

Discuss

Answer: (d).Unknown

Q9.

Select count (____ ID)
from teaches
where semester = ’Spring’ and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

Distinct

Count

Avg

Primary key

Discuss

Answer: (a).Distinct

Q10.

The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.

Or, in

Not in, in

In, not in

In, or

Discuss

Answer: (c).In, not in

Page 1 of 38

Welcome to the SQL MCQs Page

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

UNIX

Formal Languages and Automata Theory

SQL Server

Visual Basic

Operating System

Big Data Computing

Web Technologies

MATLAB

Data Structures and Algorithms