ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

94 / 120

Question 94:

View the Exhibit and examine the description of the ORDERS table. 
image
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`)