SQL 3.1-3.4 SUMMATIVE

Which SQL function is used to count the number of rows in a table?

• SUM()

• COUNT()

• GROUP()

• FILTER()

What does the GROUP BY clause do in SQL?

• It combines rows from two tables.

• It filters rows based on a condition.

• It groups rows that have the same values in specified columns.

• It limits the number of rows returned.

Which SQL keyword is used to restrict the number of rows returned in a query?

• COUNT

• LIMIT

• GROUP BY

• FILTER

What is the purpose of the HAVING clause in SQL?

• To filter records after aggregation.

• To sort the result set.

• To select distinct records.

• To count the number of rows in a table.

What does the following SQL query do? SELECT COUNT(*) FROM employees;

• Counts the number of distinct rows in the employees table.

• Counts all rows in the employees table.

• Groups the rows in the employees table.

• Filters the employees table based on a condition.

Which function can be used to calculate the average value of a numeric column in SQL?

• MAX()

• SUM()

• AVG()

• COUNT()

Which of the following statements is true about the WHERE clause?

• It is used to filter records after aggregation.

• It filters records before grouping.

• It is always used after the GROUP BY clause.

• It limits the number of rows returned.

How would you return only distinct values from a column?

• SELECT DISTINCT

• SELECT LIMIT

• SELECT UNIQUE

• SELECT GROUP BY

In which part of an SQL query would you typically use aggregate functions like COUNT(), SUM(), AVG()?

• In the WHERE clause.

• In the FROM clause.

• In the SELECT clause.

• In the LIMIT clause.

Which clause can be used to filter the results of a grouped query?

• WHERE

• ORDER BY

• LIMIT

• HAVING