ExamTopics Logo
Mail Us[email protected]
Menu
Dell Discussions
exam questions

Exam E20-007 All Questions

View all questions & answers for the E20-007 exam
Go to Exam

Exam E20-007 topic 1 question 21 discussion

Actual exam question from Dell's E20-007
Question #: 21
Topic #: 1
[All E20-007 Questions]

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?

  • A. (pn, vn)
  • B. ( (pn, vn), (pn) )
  • C. ( (pn, vn) , (pn), (vn) )
  • D. ( (pn, vn) , (pn), (vn) , ( ) )
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by pavilu at April 5, 2025, 3:38 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel