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

Q241.

Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints

Discuss

Answer: (d).0

Q242.

Which of the following SQL commands can be used to add data to a database table?

ADD

UPDATE

APPEND

INSERT

Discuss

Answer: (d).INSERT

Q243.

Which of the following join is also called as an 'inner-join'?

Non-Equijoin

Self-Join

Equijoin

None of these

Discuss

Answer: (c).Equijoin

Q244.

The result of a SQL SELECT statement is a ________ .

file

report

table

form

Discuss

Answer: (c).table

Q245.

Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and <80;

SELECT name, course_name FROM student WHERE age>50 and age <80;

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

None of these

Discuss

Answer: (b).SELECT name, course_name FROM student WHERE age>50 and age <80;

Q246.

How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '_r%';

Discuss

Answer: (a).SELECT * FROM student WHERE name LIKE 'r%';

Q247.

Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

Both a and b

None of the above

Discuss

Answer: (b).SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

Q248.

Select the right statement to insert values to the student table.

INSERT student VALUES (

INSERT VALUES (

INSERT INTO student VALUES (

INSERT VALUES INTO student (

Discuss

Answer: (c).INSERT INTO student VALUES (

Q249.

............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

EQUIJOIN

NON-EQUIJOIN

OUTER JOIN

NATURAL JOIN

Discuss

Answer: (b).NON-EQUIJOIN

Q250.

In SQL, which command is used to change a table's storage characteristics?

ALTER TABLE

MODIFY TABLE

CHANGE TABLE

None of these

Discuss

Answer: (a).ALTER TABLE

Page 25 of 38

Welcome to the SQL MCQs Page

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

Data Structures and Algorithms

Compiler Design

CompTIA PenTest+ Certification Exam PT0 002

Management Information Systems

JavaScript

Object Oriented Programming

SQL Server

Artificial Intelligence

Cloud Computing