New Features for Administrators - Question 060

The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle9i 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

Answer: A

Explanation:

Default degree of precision of fractional seconds for TIMESTAMP data type is 6 digits.

Incorrect Answers

B: Default degree of precision of fractional seconds for TIMESTAMP data type is not 9 digits. It’s 6 digits.

C: Default degree of precision is 6 digits, not 12 digits.

D: It is not 22 digits.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 266-278

Chapter 5: Language Enhancements

Oracle 9i New Features, Robert Freeman, p. 139-146

Chapter 5: Miscellaneous Oracle9i Features and Enhancements