In SQL$,$ what is the difference between the ROLLUP and CUBE operators used in GROUP BY clauses?

Group of answer choices

ROLLUP and CUBE are essentially the same, with the only difference being that CUBE can perform faster calculations in distributed database systems.

ROLLUP generates a result set that shows aggregates for a hierarchy of values in the selected columns, while CUBE generates aggregates for all possible combinations of the selected columns.

CUBE is used exclusively for numerical data types to calculate sums and averages, whereas ROLLUP can be used with any data type to generate hierarchical aggregates.

CUBE generates a result set that excludes the grand total, focusing instead on subtotals within groups. ROLLUP provides a grand total for all rows, ignoring individual group subtotals.