Oracle
1Z0-071 · Question #146
Examine the structure of the PROMOTIONS table: (Choose the best answer.) Management requires a report of unique promotion costs in each promotion category. Which query would satisfy this requirement?
The correct answer is A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1. See the full explanation below for the reasoning.
Question
Examine the structure of the PROMOTIONS table: (Choose the best answer.) Management requires a report of unique promotion costs in each promotion category. Which query would satisfy this requirement?
Exhibit
Options
- ASELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
- BSELECT promo_category, DISTINCT promo_cost FROM promotions
- CSELECT DISTINCT promo_cost, promo_category FROM promotions
- DSELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;
How the community answered
(35 responses)- A80% (28)
- B6% (2)
- C3% (1)
- D11% (4)
Community Discussion
No community discussion yet for this question.