The ____ datatype contains valid dates that range from January 1,4712 B.C.to December 31,9999 A.D.
A) DATE
B) SYSDATE
C) TIMESTAMP
D) TIME

Question

Quizplus · Accepted Answer

The DATE datatype in Oracle database contains valid dates that range from January 1, 4712 B.C. to December 31, 9999 A.D. It is the most appropriate data type for storing date and time information. SYSDATE is a built-in function that returns the current system date and time, TIMESTAMP is a data type that stores date and time down to fractions of a second, and TIME is a data type that represents a specific time of day.

The ____ Datatype Contains Valid Dates That Range from January