Oracle
1Z0-061 · Question #282
View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. You need to produce a report that provides the name, cost, and start…
The correct answer is D. SELECT promo_name, promo_cost, promo_begin_date. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000. Which SQL statement would you use?
Options
- ASELECT promo_name, promo_cost, promo_begin_date
- BSELECT promo_name, promo_cost, promo_begin_date
- CSELECT promo_name, promo_cost, promo_begin_date
- DSELECT promo_name, promo_cost, promo_begin_date
How the community answered
(31 responses)- A13% (4)
- B6% (2)
- C3% (1)
- D77% (24)
Community Discussion
No community discussion yet for this question.