Which of the following are the five built-in functions provided by SQL?
A. COUNT, SUM, AVG, MAX, MIN
B. SUM, AVG, MIN, MAX, MULT
C. SUM, AVG, MULT, DIV, MIN
D. SUM, AVG, MIN, MAX, NAME
Answer: Option A
Solution (By Examveda Team)
Option A: COUNT, SUM, AVG, MAX, MIN - These are the five built-in aggregate functions provided by SQL:COUNT: Returns the number of rows that match a specified criterion.
SUM: Returns the sum of values in a numeric column.
AVG: Returns the average of values in a numeric column.
MAX: Returns the maximum value in a column.
MIN: Returns the minimum value in a column.
Option B: SUM, AVG, MIN, MAX, MULT - "MULT" is not a standard SQL function. This option is incorrect. Option C: SUM, AVG, MULT, DIV, MIN - "MULT" and "DIV" are not standard SQL functions. This option is incorrect. Option D: SUM, AVG, MIN, MAX, NAME - "NAME" is not a standard SQL function. This option is incorrect. Conclusion:
The five built-in functions provided by SQL for performing aggregate calculations on data are Option A: COUNT, SUM, AVG, MAX, MIN.
This Question Belongs to Database >> Introduction To SQL
What are those terms refers?