Question

28. Which of the following is true about a group function?
(1 Point)
A - Group functions operate on sets of rows to produce multiple results per group.
B - DISTINCT keyword makes a group function consider duplicate values.
C - Group functions ignore null values.
D - None of the above.​

Answer 1

Answer:

group functions ignore null values

Answer 2

Answer:

Explanation:

Group functions ignore null values- is true about a group function.

Mathematical operations on sets of rows to produce one result per set are known as group functions. Group functions, often known as aggregate functions, can take the following forms: AVG, which determines the average of the chosen columns in a collection of rows, and COUNT, which determines the total number of rows in a collection.

One result per group is produced by group functions when applied to sets of rows. Group Activities Group functions, as opposed to single-row functions, work on sets of rows to produce one result per group. The entire table or the table divided into groups may be included in these sets.

A function can only take into account non-duplicate values if the DISTINCT keyword is used.

So we can say option (c) is the correct.The group functions that don't care about NULL values are MAX, COUNT, and SUM.

#SPJ2