Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

© examsnet.com

Question : 8 of 50

Marks: +1, -0

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.)

WHERE order_date_IN ( TO_DATE('OCT 21 2003','MON DD YYYY'), TO_CHAR('NOV 21 2003','MON DD YYYY') )
WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),'MON DD YYYY')
WHERE TO_CHAR(order_date,'MON DD YYYY') = 'JAN 20 2003'
WHERE order_date > TO_DATE('JUL 10 2006','MON DD YYYY')

Go to Question:

Advertisements