The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle database greater flexibility in supporting locality preferences.
What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?
A.
6 digits
B.
9 digits
C.
12 digits
D.
22 digits
Explanation:
TIMESTAMP[(precision)]
where the optional parameter precision specifies the number of digits in the fractional part of the seconds field. You cannot use a symbolic constant or variable to specify the precision; you must use an integer literal in the range 0 .. 9. The default is 6. REF.: Oracle(r) PL/SQL User’s Guide and Reference, 3-13