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

Q321.

Which of the following commands do we use to delete all the tuples from a relation (R)?

delete table R

drop table R

delete from R

drop from R

Discuss

Answer: (c).delete from R

Q322.

Choose the correct command to delete an attribute A from a relation R

alter table R delete A

alter table R drop A

alter table drop A from R

delete A from R

Discuss

Answer: (b).alter table R drop A

Q323.

create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));
Choose the correct option regarding the above statement

The statement is syntactically wrong

It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

Discuss

Answer: (c).It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

Q324.

What does the notnull integrity constraint do?

It ensures that at least one tuple is present in the relation

It ensures that at least one foreign key is present in the relation

It ensures that all tuples have a finite value on a specified attribute

It ensures that all tuples have finite attributes on all the relations

Discuss

Answer: (c).It ensures that all tuples have a finite value on a specified attribute

Q325.

Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?

all

not unique

notnull

include

Discuss

Answer: (a).all

Q326.

Which of the following logical connectives is not included in SQL?

and

nor

not

Discuss

Answer: (c).nor

Q327.

The where clause is a predicate involving attributes of the relation in the ______ clause.

select

from

with

none of the mentioned

Discuss

Answer: (b).from

Q328.

select distinct dept_name
from institute;

What does the above query do?

It gives all the tuples having a distinct dept_name

It gives the dept_name attribute values of all tuples without repetition

It gives all the dept_name attribute of all the tuples

It gives all the tuples having a null value under the dept_name attribute

Discuss

Answer: (b).It gives the dept_name attribute values of all tuples without repetition

Q329.

What does the following query do?
select name, ID, branch

from student, department

where student.branch = department.branch;

It gives all values of name, ID, branch from both the relations only if all those attributes are present in both

It gives all values of name, ID, branch from their respective relations

It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

It gives the values of name, ID, branch from their respective relations where all the values are matching with each other

Discuss

Answer: (c).It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

Q330.

The ________ clause is used to list the attributes desired in the result of a query

select

from

where

create

Discuss

Answer: (a).select

Page 33 of 38

Welcome to the SQL MCQs Page

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

MongoDB

Systems Analysis and Design Methods

Data Structures and Algorithms

Artificial Intelligence

R Programming

HTML

UNIX

MS Office

Data Warehousing and OLAP