Oracle Database SQL — Question 21

In your session NLS_DATE_FORMAT is set to DD-MON-RR.

Which two queries display the year as four digits? (Choose two.)

Answer options

• A. SELECT TO_DATE(SYSDATE, 'RRRR-MM-DD') FROM DUAL;
• B. SELECT TO_CHAR(SYSDATE, MM/DD/YYYY) FROM DUAL;
• C. SELECT TO_DATE(ADD_MONTHS(SYSDATE, 6), 'dd-non-yyyy') FROM DUAL;
• D. SELECT TO_CHAR(ADD_MONTHS(SYSDATE, 6)) FROM DUAL;
• E. SELECT TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;
• F. SELECT TO_DATE(TO_CHAR(SYSDATE, 'MM/DD/YYYY'), 'MM/DD/YYYY') FROM DUAL;

Correct answer: B, E

Explanation

The correct options B and E utilize the TO_CHAR function with the format 'MM/DD/YYYY' and 'dd-mon-yyyy', which display the year in four digits. Options A and C incorrectly use TO_DATE instead of TO_CHAR, and D does not specify a date format, while F also misuses TO_DATE for the desired output format.