Aggregate Functions Quiz

What are aggregate functions also called?

• Set functions

• Row functions

• Column functions

• Data functions

What do aggregate functions produce?

• A single, summarizing value

• Multiple values

• A detailed report

• A list of values

Which clause can specify rows for aggregate functions?

• WHERE clause

• SELECT clause

• INSERT clause

• DELETE clause

What do aggregate queries do differently from non-aggregate queries?

• Take a table as a whole

• Process each row independently

• Ignore the table structure

• Focus on individual cells

What do aggregate queries construct from a table?

• New rows

• New columns

• New tables

• New cells

Which of the following is true about aggregate queries?

• They construct new rows from a table

• They delete rows from a table

• They update rows in a table

• They insert rows into a table

Which aggregate function is used to find the maximum value in a column?

• MIN(value)

• MAX(value)

• AVG(value)

• SUM(value)

What SQL keyword is used to provide more meaningful names to result sets?

• AS

• ALIAS

• NAME

• TITLE

Why might you use an ALIAS in a SQL query?

• To make the query run faster

• To provide more meaningful names

• To delete duplicate data

• To change the data type

What does the term "aggregate function" refer to in SQL?

• Functions that modify data

• Functions that return a single value

• Functions that delete data

• Functions that create tables