Multiple choice technology databases

For each DATE value in an Oracle database, which of the following information is stored (choose all that apply):

  1. second

  2. century

  3. hour

  4. year

  5. date

  6. month
Reveal answer Fill a bubble to check yourself
A,B,C,D,E,F Correct answer
Explanation

Oracle DATE type stores century, year, month, day, hour, minute, and second. All six components listed (A through F) are stored. Oracle DATE has no time zone information, but stores all the temporal components shown.

Keep practicing — related questions