Multiple choice technology databases

which of the following is the default format for date display

  1. DD-MM-YYYY

  2. DD-Mon-RR

  3. DD-Mon-YY

  4. DD-MON-RR
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle SQL, the default date format is DD-MON-RR (e.g., 07-JUL-26). This uses the RR format which automatically handles century crossing for years 0-99. MON represents the three-letter month abbreviation in uppercase. Other formats like DD-MM-YYYY or DD-Mon-YY must be explicitly specified.

Keep practicing — related questions