You work as a database administrator at vceguide.com. You study the exhibit carefully.
Exhibit
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.)
A. SELECT promo_name,promo_begin_dateFROM promotionsWHERE promo_begin_date > ’01-JAN-01’ORDER BY 1 DESC;
B. SELECT promo_name,promo_begin_date "START DATE"FROM promotionsWHERE promo_begin_date > ’01-JAN-01’ORDER BY "START DATE" DESC;
C. SELECT promo_name,promo_begin_dateFROM promotionsWHERE promo_begin_date > ’01-JAN-01’ORDER BY 2 DESC;
D. SELECT promo_name,promo_begin_dateFROM promotionsWHERE promo_begin_date > ’01-JAN-01’ORDER BY promo_name DESC;
|
Download Printable PDF. VALID exam to help you PASS. |
 |