MS SQL Server - 21 - WHERE Clause MCQ

21 – WHERE Clause MCQ

Best of luck!

1 / 25

1. What is the primary purpose of the WHERE clause in SQL?

To specify the columns to be included in the result set

To sort the result set

To filter rows based on a specified condition

To group rows into subsets

2 / 25

2. Which SQL keyword is used to filter rows in a WHERE clause based on a specific condition?

HAVING

WHERE

FILTER

SELECT

3 / 25

3. In SQL, what does the GROUP BY clause do?

Performs aggregate functions on individual rows

Sorts the result set in ascending order

Groups rows into subsets based on one or more columns

Filters rows based on a condition

4 / 25

4. Which aggregate function in SQL is used to calculate the average value of a numeric column?

COUNT

AVG

MAX

SUM

5 / 25

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

To sort rows in descending order

To filter rows after they are grouped

To filter rows before they are grouped

To calculate the sum of a column

6 / 25

6. Which SQL keyword is used to specify the column by which the result set should be sorted?

ORDER

SORT

ASC

7 / 25

7. In SQL, how can you sort the result set in descending order using the ORDER BY clause?

By using the DESC keyword after the column name

By using the SORT keyword before the column name

By using the ASC keyword after the column name

By using the ORDER DESC statement

8 / 25

8. What is the default sorting order in SQL when using the ORDER BY clause?

No sorting is applied by default

Descending (DESC)

Ascending (ASC)

Random

9 / 25

9. Which aggregate function in SQL is used to find the total number of rows in a result set?

SUM

COUNT

AVG

MAX

10 / 25

10. In SQL, which clause is used to filter rows before they are grouped?

WHERE

HAVING

ORDER BY

GROUP BY

11 / 25

11. What is the purpose of the MAX() function in SQL?

To find the smallest value in a column

To calculate the sum of a column

To calculate the average of a column

To find the largest value in a column

12 / 25

12. Which SQL keyword is used to specify a condition in the HAVING clause?

HAVING

WHERE

GROUP

FILTER

13 / 25

13. In SQL, which aggregate function is used to find the highest value in a column?

MIN

MAX

COUNT

SUM

14 / 25

14. What does the COUNT() function in SQL do?

Calculates the sum of a column

Counts the number of rows in a result set

Calculates the average of a column

Finds the highest value in a column

15 / 25

15. In SQL, what is the purpose of the SUM() function?

To count the number of rows in a result set

To calculate the total sum of a numeric column

To calculate the average of a column

To find the highest value in a column

16 / 25

16. Which SQL keyword is used to specify the order in which rows should be sorted?

HAVING

ORDER BY

WHERE

GROUP BY

17 / 25

17. What is the primary purpose of the MIN() function in SQL?

To calculate the sum of a column

To count the number of rows in a result set

To find the lowest value in a column

To find the highest value in a column

18 / 25

18. In SQL, what does the COUNT(DISTINCT) function do?

Calculates the sum of a column

Counts the number of rows in a result set

Calculates the average of a column

Counts the number of unique values in a column

19 / 25

19. What is the purpose of the AVG() function in SQL?

To find the highest value in a column

To calculate the sum of a column

To calculate the average value of a numeric column

To count the number of rows in a result set

20 / 25

20. In SQL, which aggregate function is used to find the lowest value in a column?

MAX

COUNT

SUM

MIN

21 / 25

21. What is the purpose of the ORDER BY clause in SQL?

To filter rows based on a condition

To sort the result set based on one or more columns

To calculate aggregate functions

To group rows into subsets

22 / 25

22. In SQL, what is the default sorting order when using the ORDER BY clause without specifying ASC or DESC?

Ascending (ASC)

Descending (DESC)

Random

No sorting is applied by default

23 / 25

23. Which SQL keyword is used to specify the columns to be included in the result set of a SELECT query?

GROUP BY

WHERE

FROM

SELECT

24 / 25

24. What is the primary purpose of the HAVING clause in SQL?

To filter rows before they are grouped

To specify the order of columns in the result set

To filter rows after they are grouped

To calculate aggregate functions

25 / 25

25. In SQL, what is the purpose of the GROUP BY clause?

To sort the result set in descending order

To group rows into subsets based on one or more columns

To calculate aggregate functions on individual rows

To filter rows based on a condition

Your score is

MS SQL Server – 21 – WHERE Clause MCQ