Home / SQL / SQL Quiz | Software Testing Material

SQL Quiz | Software Testing Material

ByRajkumar Updated onFebruary 13, 2025

Welcome to SQL Quiz. This quiz consists 40 SQL multiple choice questions. There is no negative marking in this.

SQL MCQ (Multiple Choice Questions)

Put your SQL expertise to the test with our engaging SQL Quiz. We have created this SQL Quiz Online Test to help you master in SQL.

Which SQL statement is used to remove rows from a table?

DELETE

DROP

ELIMINATE

REMOVE

None

Which SQL statement is used to modify the existing records in a table?

UPDATE

MODIFY

EDIT

SAVE

None of the above

None

The UNION operator is used to

Combine the result-set of no more than two SELECT statements and must have the same number of columns

Combine the result-set of no more than two SELECT statements and doesn't have the same number of columns

Combine the result-set of two or more SELECT statements and must have the same number of columns

Combine the result-set of two or more SELECT statements and doesn't have the same number of columns

None

The MIN() function returns the smallest value of the selected column and The MAX() function returns the largest value of the selected column

True

False

None

Which SQL statement is used to extract data from a database?

EXTRACT

GET

SELECT

None of the above

None

Which SQL statement is used to insert new rows of data to a table in a database

ADD

APPEND

ADJUST

INSERT

None

Which of the following keyword you use to modify the existing value in an UPDATE query?

EDIT

UPDATE

SET

VALUE

None

With SQL, how do you select all the columns from a table named "Employees"?

SELECT FROM Employees

SELECT * Employees

SELECT * FROM Employees

SELECT [all] FROM Employees

None

The table rows are also known as

Records

Attributes

Fields

None of the above

None

10.

The AND operator displays a record if all the conditions separated by AND are TRUE

True

False

None

11.

Which SQL statement is used to delete complete data from an existing table?

DELETE

REMOVE

TRUNCATE

None of the above

None

12.

Subqueries can be nested multiple times

True

False

None

13.

Which type of database management system represents relations using tables?

Hierachical DBMS

Object Oriented DBMS

Relational DBMS

None of the above

None

14.

The OR operator displays a record if any of the conditions separated by OR is TRUE

True

False

None

15.

Which function returns the difference between two dates

DATEDIFFERENCE()

DATEDIFF()

DATESUB()

DATESUBTRACT()

None

16.

Which SQL statement is used to delete complete data from an existing table & table structure from the database?

DROP

DELETE

TRUNCATE

None of the above

None

17.

The table columns are also known as

Records

Attributes

Fields

None of the above

None

18.

Which SQL statement is used to return only different values?

SELECT DIFFERENT ColumnName FROM TableName;

SELECT DISTINCT ColumnName FROM TableName;

SELECT UNIQUE ColumnName FROM TableName;

None of the above

None

19.

A NULL value is different than a zero value or a field that contains spaces

True

False

None

20.

What is the keyword you use to group the result by a column's values?

GROUP BY

ORDER BY

None

21.

With SQL, how do you select a column named "FirstName" from a table named "Employees"?

SELECT * FROM Employees

SELECT FirstName FROM Employees

SELECT FROM Employees.FirstName

SELECT * FirstName FROM Employees

None

22.

Which of the following is not a Data Definition Language (DDL) statement?

ALTER

CREATE

RENAME

UPDATE

None

23.

Which of the following is not a RDBMS?

MySQL

MongoDB

NexusDB

PostgreSQL

None

24.

Which SQL keyword is used to sort the data in ascending or descending order, based on one or more columns

SORT

SORT BY

ORDER

ORDER BY

None

25.

The result of a SELECT statement can contain duplicate rows

True

False

None

26.

Which of the following is not a part of SQL

Data Control Language

Data Definition Language

Data Manipulation Language

Data Structured Language

None

27.

Which statement is correct

To sort in ascending or descending order we can use the keywords ASC or DESC respectively

To sort in ascending or descending order we can use the keywords DESC or ASC respectively

To sort in ascending or descending order we can use the keywords AESC or DSC respectively

To sort in ascending or descending order we can use the keywords DSC or AESC respectively

None

28.

What does SQL stand for?

Structured Query Language

Structured Queries Language

Structured Question Language

None of the above

None

29.

Which of the following is not an SQL Aggregate function

AVG()

ABS()

COUNT()

SUM()

None

30.

Which SQL keyword you use to merge two tables based on a matching column?

AND

ATTACH

JOIN

MERGE

None

Time's up

You can find answers along with the explanation in the end of this quiz.

Knowledge Base:

Software Testing Quiz (Software Testing MCQs)
Selenium Quiz (Selenium MCQs)
Automation Testing Quiz (Automation Testing MCQs)
Performance Testing Quiz
ISTQB Quiz (ISTQB MCQs)
Java Quiz (Java MCQs)
JIRA Quiz (JIRA MCQs)
SQL Tutorial
SQL Interview Questions

Like This Post?

Subscribe and get free access to subscriber-only guides, templates, and checklists.

You are subscribing to email updates. Unsubscribe anytime. Your data is safe.

Rajkumar

Rajkumar SM is the founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and a blogger and YouTuber by choice. He has extensive experience in the field of Software Testing. Furthermore, he loves spending time with his wife and their cute little kid, 'Freedom.'

Java Quiz | Software Testing Material

10 Best Service Virtualization Tools (Free & Paid) in 2025