10 SQL Multiple Choice Questions (MCQs) 

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

A. GET
B. SELECT
C. FETCH
D. READ

✅ Answer: B. SELECT

---

2. What does the WHERE clause do in SQL?

A. Groups records
B. Filters records
C. Sorts records
D. Deletes records

✅ Answer: B. Filters records

---

3. Which SQL function is used to count the number of rows?

A. COUNT()
B. SUM()
C. TOTAL()
D. LENGTH()

✅ Answer: A. COUNT()

---

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

A. ORDER
B. GROUP
C. SORT
D. ORDER BY

✅ Answer: D. ORDER BY

---

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

A. Random
B. Descending
C. Ascending
D. Alphabetical

✅ Answer: C. Ascending

---

6. What does the SQL JOIN clause do?

A. Combines rows from multiple tables
B. Deletes rows from a table
C. Finds duplicates
D. Creates new tables

✅ Answer: A. Combines rows from multiple tables

---

7. Which JOIN returns only the matching rows from both tables?

A. LEFT JOIN
B. RIGHT JOIN
C. INNER JOIN
D. FULL OUTER JOIN

✅ Answer: C. INNER JOIN

---

8. Which SQL keyword is used to remove duplicates from a result set?

A. NO DUPLICATES
B. REMOVE
C. DISTINCT
D. UNIQUE

✅ Answer: C. DISTINCT

---

9. What is the purpose of the GROUP BY clause?

A. Sort data by groups
B. Summarize data into groups
C. Filter grouped data
D. Rearrange column order

✅ Answer: B. Summarize data into groups

---

10. What does the LIKE operator do in SQL?

A. Joins tables
B. Deletes records
C. Filters with pattern matching
D. Adds new columns

✅ Answer: C. Filters with pattern matching