Aggregate Functions in DBMS Quiz

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What does the COUNT(*) function do?

Counts all the number of rows of the table including null (correct)
Sums up the values in the column
Counts number of non-null values in a column
Counts number of distinct values in a column

When is the DISTINCT keyword used?

To return the number of rows in the result
To find the maximum value in a column
To calculate the total sum of values in a column
To perform calculations on unique values of a column (correct)

Which aggregate function returns the average value of a numeric column?

COUNT
SUM
MAX
AVG (correct)

What does the MAX function do?

<p>Finds the maximum value in the column (B)</p> Signup and view all the answers

What does the SUM function do?

<p>Sums up the values in the column (C)</p> Signup and view all the answers

Study Notes

Aggregate Functions

The COUNT(*) function returns the total number of rows in a table or a specified column.
The DISTINCT keyword is used to select only unique values from a column, eliminating duplicate values.
The AVG function returns the average value of a numeric column.
The MAX function returns the highest value in a numeric column.
The SUM function calculates the total value of a numeric column by adding up all the values.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge of aggregate functions in DBMS with this quiz. Explore the syntax and usage of aggregate functions like AVG, and practice writing queries to calculate average values from database tables.