In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Home / Engineering / Database Management System (DBMS) / Question

Mr. Dubey • 51.43K Points
Coach

Q.) In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

(A) to ﬁnd the groups forming the subtotal in a row

(B) to create group-wise grand totals for the groups speciﬁed within a group by clause

(C) to create a grouping for expressions or columns speciﬁed within a group by clause in one direction, from right to left for calculating the subtotals

(D) to create a grouping for expressions or columns speciﬁed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals

Correct answer : Option (C) - to create a grouping for expressions or columns speciﬁed within a group by clause in one direction, from right to left for calculating the subtotals

Discusssion

Related MCQs on Database Management System (DBMS)

Q. What is a business logic object?

Q. Buffering is done to

Q. What is the name of Rackspace’s cloud service?

Q. What is a variable defined outside a function referred to as?

Q. Support vectors are the data points that lie closest to the decision

Q. Virtualization allows sharing the resources of hardware across multiple a environments.

Q. the complexity of quicksort is O(nlog n).

Q. Which of the following is not a valid size of a Floppy Disk?

Q. A multiplexer is a logic circuit that

Q. What would you do in PCA to get the same projection as SVD?