Exam 1z0-071 topic 1 question 72 discussion

create table channels_order ( channel_type varchar2(50), month date, code varchar2(5), sales number); insert into channels_order values('internet','2009-09','GB',16569); insert into channels_order values('internet','2009-09','US',124224); insert into channels_order values('internet','2009-10','GB',14539); insert into channels_order values('internet','2009-10','US',137054); insert into channels_order values('direct sales','2009-09','GB',85223); insert into channels_order values('direct sales','2009-09','US',638201); insert into channels_order values('direct sales','2009-10','GB',91925); insert into channels_order values('direct sales','2009-10','US',682297); select channel_type,month,code,sum(sales) sums from channels_order ch group by channel_type,rollup(month,code);

D is correct, can't say about rollup

A for me

D is the correct answer

Ok, out of curiosity I added the first group to see the result... 16569+124224+14539+137054 = 292386. A difference of 1?? Why? Could it have been a sum of undisplayed decimal values?

As per my understanding from below link I think A is correct. https://www.oracletutorial.com/oracle-basics/oracle-rollup/#:~:text=The%20ROLLUP%20works%20as%20follows%3A%201%20First%2C%20calculate,to%20left.%203%20Finally%2C%20calculate%20the%20grand%20total.

D is the correct answer