Question

SQL has built-in functions which are also called ______ functions.

A. accumulative.
B. calculated.
C. compound.
D. aggregate.

Answer 1

SQL has built-in functions known as aggregate functions, which perform calculations on a set of data and return a single value, such as COUNT(), SUM(), and AVG().

Step-by-step explanation:

SQL, which stands for Structured Query Language, has built-in functions that allow you to perform calculations on sets of data. These functions are known as aggregate functions. Aggregate functions perform a calculation on a set of values and return a single value. For instance, you can use the COUNT() function to count the number of rows, the SUM() function to add up all the numeric values in a column, or the AVG() function to calculate the average value of a set of numbers. These functions are crucial for data analysis and can be used in conjunction with GROUP BY clauses to aggregate data according to specific criteria.