View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns
of the promotions table, and the required output format.
Which two queries give the correct result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
Which two queries give the correct result?
View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns
of the promotions table, and the required output format.
Which two queries give the correct result?
I think the only correct answer is C. D is not 100% correct because the ‘fmDD, YYYY’ clause will take the trailing 0 out from ‘Friday, January 01, 1999) to make it ‘Friday, January 1, 1999).
Really!. FM is a convertion function and returns a value with no leading zeros or trailing blanks. And the image exhibit for analises show the last row Friday, January 1, 1999, without zero. Only c is correct.