Oracle
1Z0-061 · Question #194
View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended in…
The correct answer is A. SELECT promo_name, promo_cost D. SELECT promo_name, promo_cost. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended in the time interval 15th March '00 to 15th October '00. Which two queries would give the required result? (Choose two.)
Exhibit
Options
- ASELECT promo_name, promo_cost
- BSELECT promo_name, promo_cost
- CSELECT promo_name, promo_cost
- DSELECT promo_name, promo_cost
How the community answered
(46 responses)- A74% (34)
- B9% (4)
- C17% (8)
Community Discussion
No community discussion yet for this question.