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 > T0_CHAR(ADD_M0NTHS(SYSDATE,6),’M0N DD YYYY’)
D.
WHERE order_date IN (T0_DATE(‘0ct 21 2003’,’Mon DD YYYY’),
T0_CHAR(‘N0V 21 2003’,’Mon DD YYYY’))