Oracle
1Z0-061 · Question #268
1Z0-061 Question #268: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #268. The question stem and answer options stay visible for context.
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;
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.