Question
What does the SQL CUBE operator generate?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Aggregations for all combinations of the specified grouping columns
Explanation:
CUBE returns every subtotal combination across the listed dimensions.
It can produce many groups, so designers should consider result size.
Leave a Reply