Which two statements are true about the GROUPING function? (Choose two.)
A.
It is used to find the groups forming the subtotal in a row.
B.
It is used to identify the NULL value in the aggregate functions.
C.
It is used to form the group sets involved in generating the totals and subtotals.
D.
It can only be used with ROLLUP and CUBE operators specified in the GROUP BY
clause.
A D
According with oracle documentation, about GROUPING:
“GROUPING distinguishes superaggregate rows from regular grouped rows. GROUP BY extensions such as ROLLUP and CUBE produce superaggregate rows where the set of all values is represented by null. Using the GROUPING function, you can distinguish a null representing the set of all values in a superaggregate row from a null in a regular row.”
I think the corrct answer is B and D