View the Exhibit and examine the description of the ORDERS table.
Which two WHERE clause conditions demonstrate the correct usage of conversion
functions? (Choose two.)
A.
WHERE order_date > TO_DATE(‘JUL 10 2006’,’MON DD YYYY)
B.
WHERE TO_CHAR(order_date,’MON DD YYYY) = ‘JAN 20 2003’
C.
WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),’MON DD
YYYY”)
D.
WHERE order_date IN (TO_DATE(‘Oct 21 2003’,’Mon DD YYYY”),
TO_CHAR(‘NOV 21 2003’,’Mon DD YYYY”))