Examveda

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

A. True

B. False

Answer: Option A

Solution (By Examveda Team)

SQL does indeed provide five built-in functions for aggregate operations:
COUNT: Counts the number of rows or non-null values in a column.
SUM: Calculates the sum of numeric values in a column.
AVG: Computes the average of numeric values in a column.
MAX: Retrieves the maximum value from a column.
MIN: Retrieves the minimum value from a column.
These functions are fundamental for data analysis and reporting tasks within SQL queries.
Conclusion:
The statement "SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN" is Option A: True. Hence, the correct answer is True.

This Question Belongs to Database >> Introduction To SQL

Join The Discussion

Related Questions on Introduction to SQL

The SQL WHERE clause:

A. limits the column data that are returned.

B. limits the row data are returned.

C. Both A and B are correct.

D. Neither A nor B are correct.