View the Exhibit and examine the description of the ORDERS table, (Choose two,)
Which two WHERE clause conditions demonstrate the correct usage of conversion functions?
A. WHERE Order_date_IN (TO_DATE(OCT 21 2003′, MON DD YYYY), TO_CHAR(‘NOV 21 2003’, ‘MON DD YYYY’))
B. WHERE Order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), ‘MON DD YYYY’)
C. WHERE TO_CHAR(Order_date, ‘MON DD YYYY’) = ‘JAN 20 2003’
D. WHERE Order_date > (TO_DATE(‘JUL 10 2006’, ‘MON DD YYYY’)
|
Download Printable PDF. VALID exam to help you PASS. |
 |