MS SQL Server - 88 - CUBE and ROLLUP MCQ

88 – CUBE and ROLLUP MCQ

1 / 25

1. What is the primary purpose of the CUBE operator in SQL Server?

A. Sorting result sets

B. Grouping data into subsets

D. Calculating averages

C. Generating all possible combinations of grouped data

2 / 25

2. Which operator generates a result set that includes all possible combinations of grouped data, including subtotals and grand totals?

B. ROLLUP

C. GROUP BY

A. CUBE

D. HAVING

3 / 25

3. What does the ROLLUP operator do in SQL Server?

B. Excludes subtotals from the result set

A. Generates all possible combinations of grouped data

C. Performs row-level calculations

D. Sorts the result set in descending order

4 / 25

4. Which SQL Server operator generates a result set that includes subtotals but not grand totals?

A. CUBE

C. GROUP BY

D. HAVING

B. ROLLUP

5 / 25

5. In SQL Server, which operator is used to group data based on multiple columns in a single query?

C. GROUP BY

A. CUBE

D. HAVING

B. ROLLUP

6 / 25

6. What is the result of applying the GROUP BY clause without any grouping functions in SQL Server?

B. All rows are combined into a single group.

A. No grouping is performed.

C. Rows are grouped based on a single column.

D. Rows are grouped based on multiple columns.

7 / 25

7. What is the primary purpose of the GROUPING function in SQL Server?

C. Calculating averages

D. Determining the grouping status of a column

A. Sorting result sets

B. Generating subtotals

8 / 25

8. In SQL Server, what does the GROUPING function return for a grouped column that is part of the grouping set?

B. 1

A. 0

C. NULL

D. True

9 / 25

9. Which function in SQL Server is used to calculate the average of a set of values?

B. SUM()

D. MAX()

A. AVG()

C. COUNT()

10 / 25

10. What is the purpose of the HAVING clause in SQL Server?

B. Filtering grouped data based on aggregate values

D. Performing row-level calculations

A. Grouping data

C. Sorting result sets

11 / 25

11. Which SQL Server function returns the total number of rows in a result set, including rows with NULL values?

B. SUM()

C. COUNT()

D. MAX()

A. AVG()

12 / 25

12. In SQL Server, what is the result of applying the COUNT(*) function to a grouped result set?

A. It counts the number of groups.

D. It counts the number of NULL values in each group.

C. It counts the total number of rows in each group.

B. It counts the number of distinct values in a group.

13 / 25

13. Which SQL Server function returns the highest value in a set of values?

A. AVG()

B. SUM()

D. MAX()

C. COUNT()

14 / 25

14. What does the GROUPING_ID() function in SQL Server return?

B. The identity of the highest group in a result set

C. The identity of the current grouping column

A. The number of groups in a result set

D. The number of rows in each group

15 / 25

15. In SQL Server, which operator generates a result set that includes both subtotals and grand totals?

D. HAVING

B. ROLLUP

A. CUBE

C. GROUP BY

16 / 25

16. What is the primary purpose of the GROUPING SETS operator in SQL Server?

A. Sorting result sets

D. Performing row-level calculations

C. Filtering grouped data

B. Generating subtotals and grand totals

17 / 25

17. In SQL Server, how can you use the GROUPING SETS operator to specify multiple grouping sets in a single query?

B. Use the ROLLUP operator.

C. Use the GROUPING SETS clause with a comma-separated list of expressions.

A. Use the GROUP BY clause with multiple columns.

D. Use the HAVING clause.

18 / 25

18. Which SQL Server function returns the sum of a set of values?

D. MAX()

B. SUM()

C. COUNT()

A. AVG()

19 / 25

19. In SQL Server, what is the primary purpose of the GROUP BY clause?

A. Sorting result sets

C. Filtering grouped data

D. Performing row-level calculations

B. Generating subtotals and grand totals

20 / 25

20. What is the result of applying the GROUPING function to a non-grouping column in SQL Server?

B. 1

A. 0

C. NULL

D. True

21 / 25

21. In SQL Server, what does the GROUPING function return for a grouped column that is not part of the grouping set?

C. NULL

A. 0

B. 1

D. True

22 / 25

22. What is the purpose of the GROUPING SETS operator in SQL Server?

B. Generating subtotals and grand totals

D. Calculating averages

C. Filtering grouped data

A. Sorting result sets

23 / 25

23. Which SQL Server function returns the lowest value in a set of values?

B. SUM()

D. MIN()

C. COUNT()

A. AVG()

24 / 25

24. In SQL Server, what does the GROUPING_ID() function return for a non-grouping column?

C. The identity of the current grouping column

B. The identity of the highest group in a result set

A. The number of groups in a result set

D. NULL

25 / 25

25. In SQL Server, what does the GROUPING SETS operator do when used in conjunction with GROUP BY?

C. It filters rows based on a condition.

B. It sorts the result set in ascending order.

A. It generates all possible combinations of grouped data.

D. It specifies the order of rows in the result set.

Your score is

MS SQL Server – 88 – CUBE and ROLLUP MCQ