Which statement best describes the GROUPING function?
A.
It is used to set the order for the groups to be used for calculating the grand totals and subtotals.
B.
It is used to form various groups to calculate total and subtotals created using ROLLUP and CUBE operators.
C.
It is used to identify if the NULL value in an expression is a stored NULL value or created by ROLLUP or CUBE.
D.
It is used to specify the concatenated group expressions to be used for calculating the grand totals and subtotals.
For me the answer is D. But I have a pdf testKing 1Z0-047 and the answer shown is the B.
i don’t think answer is D… because of “concatenated group expressions”
THE RIGHT ANSWER IS C. BY USING IT YOU CAN DIFFERENTIATE NULL VALUES FROM NULL VALUES CREATED BY ROLLUP AND CUBE FUNCTION
B is for GROUPING SETS
i guess D, some for this link:
http://certificationpath.com/e/1z0-047-s/questions/which-statement-best-describes-the-grouping-functionya-it-is-used-to-set-q10828
Option C is correct:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions064.htm#SQLRF00647
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.
C