Oracle
1Z0-061 · Question #268
View the Exhibit; examine the structure of the PROMOTIONS table. Each promotion has a duration of at least seven days. Your manager has asked you to generate a report, which provides the weekly cost…
The correct answer is D. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions. See the full explanation below for the reasoning.
Question
View the Exhibit; examine the structure of the PROMOTIONS table. Each promotion has a duration of at least seven days. Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date. Which query would achieve the required result?
Exhibit
Options
- ASELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions;
- BSELECT promo_name, (promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;
- CSELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;
- DSELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C4% (1)
- D86% (24)
Community Discussion
No community discussion yet for this question.