Oracle Exam 1Z0-082 Topic 12 Question 33 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 33
Topic #: 12

[All 1Z0-082 Questions]

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.

Which two queries can be used? (Choose two.)

ASELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

BSELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

CSELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

DSELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

ESELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Show Suggested Answer

Suggested Answer: C, E

by Talia at May 04, 2022, 03:03 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!