SQL (Structured Query Language) MCQs in DBMS

1. Which SQL statement is used to retrieve data from a database?

(A) SELECT

(B) INSERT

(C) UPDATE

(D) DELETE

2. Which clause is used to filter records in a SQL query?

(A) ORDER BY

(B) GROUP BY

(C) HAVING

(D) WHERE

3. What is the purpose of the JOIN operation in SQL?

(A) To combine data from multiple tables

(B) To update existing records

(C) To delete records from a table

(D) To create new tables

4. Which SQL keyword is used to sort the result set?

(A) SORT BY

(B) ORDER BY

(C) GROUP BY

(D) FILTER BY

5. Which SQL statement is used to insert new records into a table?

(A) UPDATE

(B) INSERT INTO

(C) SELECT

(D) DELETE

6. What is the default sorting order of the ORDER BY clause?

(A) Descending

(B) Ascending

(C) Random

(D) Alphabetical

7. Which function is used to calculate the total number of rows in a table?

(A) COUNT()

(B) SUM()

(C) AVG()

(D) MAX()

8. What is the purpose of the GROUP BY clause in SQL?

(A) To filter records based on aggregate functions

(B) To sort the result set

(C) To group rows that have the same values in specified columns

(D) To join multiple tables

9. Which SQL statement is used to update existing records in a table?

(A) MODIFY

(B) UPDATE

(C) INSERT INTO

(D) CHANGE

10. Which SQL keyword is used to remove all records from a table, but not the table itself?

(A) DELETE

(B) DROP

(C) TRUNCATE

(D) REMOVE

11. Which SQL clause is used to aggregate data in a query?

(A) WHERE

(B) HAVING

(C) JOIN

(D) GROUP BY

12. What is the purpose of the HAVING clause in SQL?

(A) To filter groups of rows based on a specified condition

(B) To filter individual rows based on a specified condition

(C) To sort the result set

(D) To combine data from multiple tables

13. Which SQL function is used to find the maximum value in a column?

(A) MAX()

(B) MIN()

(C) SUM()

(D) AVG()

14. What does the DISTINCT keyword do in a SQL query?

(A) It orders the result set.

(B) It ensures that the result set contains only unique values.

(C) It calculates the average value of a column.

(D) It groups the result set by specified columns.

15. Which SQL clause is used to specify the columns to be retrieved in a SELECT statement?

(A) FROM

(B) SELECT

(C) WHERE

(D) ORDER BY

16. What is the function of the UNION operator in SQL?

(A) To combine rows from two or more SELECT queries into a single result set

(B) To join two tables based on a related column

(C) To update records in a table

(D) To delete records from a table

17. Which of the following SQL statements will create a new table?

(A) ALTER TABLE

(B) CREATE TABLE

(C) DROP TABLE

(D) MODIFY TABLE

18. What does the SQL command ALTER TABLE do?

(A) Deletes a table

(B) Creates a new table

(C) Modifies an existing table structure

(D) Inserts data into a table

19. Which SQL clause is used to specify the table from which to retrieve data?

(A) SELECT

(B) FROM

(C) WHERE

(D) ORDER BY

20. What does the SQL command DROP TABLE do?

(A) Deletes all records in the table but keeps the table structure

(B) Deletes the table structure and all records in the table

(C) Modifies the structure of the table

(D) Creates a new table