Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 49 of 57

Marks: +1, -0

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

SELECT DISTINCT promo_category || ‘ has ’ || promo_cost AS COSTS FROM promotions ORDER BY 1;
SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
SELECT DISTINCT promo_cost || ‘ in ’|| DISTINCT promo_category FROM promotions ORDER BY 1;
SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

Go to Question:

Prev Question

Next Question