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’))
|
Download Printable PDF. VALID exam to help you PASS. |
 |