SQL MCQ for Exams Quiz - 4

1. How do you remove duplicate rows from a result set?

SELECT DISTINCT

SELECT UNIQUE

SELECT REMOVE DUPLICATES

SELECT EXCLUSIVE

2. Which function in SQL is used to find the number of rows in a table?

SUM()

COUNT()

MAX()

AVG()

3. In which SQL clause is the `GROUP BY` statement used?

WHERE

SELECT

FROM

ORDER BY

4. Which of the following is a correct SQL query to find the maximum salary from the "Employees" table?

SELECT MAX(salary) FROM Employees

SELECT salary FROM Employees ORDER BY salary DESC

SELECT HIGHEST(salary) FROM Employees

SELECT MAXIMUM(salary) FROM Employees

5. Which SQL keyword is used to restrict the number of rows returned by a query?

LIMIT

REDUCE

RESTRICT

FILTER

6. Which SQL function returns the current date and time?

CURRENT_DATE()

GETDATE()

NOW()

TODAY()

7. Which SQL statement is used to create an index on a table?

CREATE INDEX

ADD INDEX

INSERT INDEX

NEW INDEX

8. Which SQL keyword is used to retrieve a specific number of records from the top of a result set?

LIMIT

TOP

MAX

FIRST

9. Which SQL keyword is used to combine rows from two or more tables, based on a related column between them?

COMBINE

JOIN

UNION

MERGE

10. Which SQL function is used to calculate the total sum of a numeric column?

AVG()

TOTAL()

COUNT()

SUM()

---

---

Your Result

Your Score

Score in percentage

Answers 1

Answers 2

Answers 3

Answers 4

Answers 5

Answers 6

Answers 7

Answers 8

Answers 9

Answers 10