Exam 1z0-071 topic 1 question 72 discussion

Actual exam question from Oracle's 1z0-071

Question #: 72
Topic #: 1

Examine this partial query:

Examine this output:

Which GROUP BY clause must be added so the query returns the results shown?

A. GROUP BY ch.channel_type, ROLLUP(t.month, co.country_code);
B. GROUP BY ch.channel_type, t.month, ROLLUP(co.country_code);
C. GROUP BY CUBE(ch.channel_type, t.month, co.country_code);
D. GROUP BY ch.channel_type, t.month, co.country_code;

Show Suggested Answer

Suggested Answer: A 🗳️

by fgramos at June 12, 2023, 7:17 p.m.

Comments

Submit Cancel

acd3ea6

9 months ago

Selected Answer: A

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);

upvoted 1 times

...

2 years ago

D is the correct answer

upvoted 2 times

...