Question 94:
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.)
Answer options:
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`)