Dell-EMC
E20-007 · Question #112
E20-007 Question #112: Real Exam Question with Answer & Explanation
The correct answer is D. ( (pn,vn),(pn),(vn),( ) ). See the full explanation below for the reasoning.
Question
Review the following code: SELECT pn, vn, sum(prc*qty) FROM sale GROUP BY CUBE(pn, vn) ORDER BY 1, 2, 3; Which combination of subtotals do you expect to be returned by the query?
Options
- A(pn,vn)
- B( (pn,vn),(pn) )
- C( (pn,vn),(pn),(vn) )
- D( (pn,vn),(pn),(vn),( ) )
Community Discussion
No community discussion yet for this question.