Multiple choice technology

What will be the output of the following expressions where Date1=04/12/98 and Date2=11/09/01? TO_DATE(Date1, MM/DD/RR') TO_DATE(Date2,MM/DD/YY')

  1. 04/12/1998 00:00:00 and 11/09/1901 00:00:00

  2. 04/12/1998 00:00:00 and 11/09/2001 00:00:00

  3. 04/12/2098 00:00:00 and 11/09/1901 00:00:00

  4. 04/12/2098 00:00:00 and 11/09/2001 00:00:00

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The RR format code interprets two-digit years relative to the current century (assuming cutoff year 50), so 04/12/98 with RR becomes 04/12/1998. The YY format interprets years literally within the current century's window, so 11/09/01 with YY becomes 11/09/1901. The RR format is Y2K-compliant as it intelligently handles century rollover, while YY has a fixed interpretation that can place dates in the wrong century.