SQL Quiz #5 – Grouping Sets

The GROUPING and GROUPING_ID functions helps you to:

What does the GROUP BY CUBE clause return?

Which of the following is correct about the GROUP BY ROLLUP clause?

Which of the following is true regarding NULL from a result set where multiple grouping sets were used?

Will the following statement execute successfully?

SELECT [Category]
      ,[Subcategory]
      ,COUNT(*) AS [NoProducts]
FROM [dbo].[ProductStock]
GROUP BY [Category];

Which option enables you to apply filters on grouped data?

The following query:

SELECT [Name], [Year], SUM([Sales])

FROM [dbo].[Product]

GROUP BY GROUPING SETS (([Name]), ([Year]))

Is equivalent with?

Which of the following functions can be used with a GROUP BY clause?