Oracle
1Z0-071 · Question #93
View the exhibit and examine the structure of the PROMOTIONS table. You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the…
The correct answer is C. SELECT promo_name, promo_begin_date FROM promotions. See the full explanation below for the reasoning.
Question
View the exhibit and examine the structure of the PROMOTIONS table. You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the ‘INTERNET’ category. Which query would give you the required output?
Exhibit
Options
- ASELECT promo_name, promo_begin_date FROM promotions
- BSELECT promo_name, promo_begin_date FROM promotions
- CSELECT promo_name, promo_begin_date FROM promotions
- DSELECT promo_name, promo_begin_date FROM promotions
How the community answered
(34 responses)- A6% (2)
- B18% (6)
- C74% (25)
- D3% (1)
Community Discussion
No community discussion yet for this question.