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;
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.