Oracle
1Z0-082 · Question #153
1Z0-082 Question #153: Real Exam Question with Answer & Explanation
The correct answer is B. WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019' E. WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY'). See the full explanation below for the reasoning.
Question
The orders table has a column ORDER_DATE of data type date. The default display format for a date Is DD-MON-RR. Which two where conditions demonstrate the correct usage of conversion functions?
Options
- AWHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
- BWHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
- CWHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
- DWHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018',
- EWHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
Community Discussion
No community discussion yet for this question.