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.)
Answer options
A
SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC;
B
SELECT promo_name, promo_begin_date FROM promotions ORDER BY promo_begin_date;
C
SELECT promo_name FROM promotions WHERE promo_begin_date > '01-JAN-01';
D
SELECT * FROM promotions ORDER BY promo_begin_date DESC;
Correct answer: SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC;
Explanation
Quick AnswerThe correct answer is SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC; because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.