Oracle
1Z0-061 · Question #196
View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001, starting with the latest…
The correct answer is A. . SELECT promo_name, promo_begin_date FROM promotions D. . SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE. 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 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 FROM promotions
- B. SELECT promo_name. promo_begiii_date FROM promotions
- C. SELECT promo_name. promo_begin_date FROM promotions
- D. SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE
How the community answered
(45 responses)- A80% (36)
- B7% (3)
- C13% (6)
Community Discussion
No community discussion yet for this question.