In your session NLS_ DATE_ FORMAT is set to DD–MON_RR. Which two queries display the year as four digits?

A . True. The TO_CHAR function will convert SYSDATE to a string using the format 'MM/DD/YYYY',

which displays the year as four digits. Then TO_DATE will convert this string back to a date without

changing its appearance because the format matches.

E . True. The TO_CHAR function with the format 'MM/DD/YYYY' will display the date with the year as

four digits, regardless of the NLS_DATE_FORMAT setting.

B, C, D, and F are incorrect because they either do not specify the format model needed to display

the year as four digits or use TO_DATE which does not format the output but rather interprets the

input.

Reference: Oracle Database SQL Language Reference 12c, Datetime Functions - TO_DATE, TO_CHAR