Oracle
1Z0-061 · Question #141
You work as a database administrator at ABC.com. You study the exhibit carefully. Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001 starting with the…
The correct answer is B. SELECT promo_name, promo_begin_date "START DATE" C. . SELECT promo_name, promo_begin_date. See the full explanation below for the reasoning.
Question
You work as a database administrator at ABC.com. You study the exhibit carefully. Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001 starting with the latest promo. Which query would give the required result? (Choose all that apply.)
Exhibit
Options
- A. SELECT promo_name, promo_begin_date
- BSELECT promo_name, promo_begin_date "START DATE"
- C. SELECT promo_name, promo_begin_date
- D. SELECT promo_name, promo_begin_date
How the community answered
(26 responses)- A8% (2)
- B85% (22)
- D8% (2)
Community Discussion
No community discussion yet for this question.