PrepAway - Latest Free Exam Questions & Answers

which attributes?

By default, a column defined as a TIMESTAMP includes which attributes?

PrepAway - Latest Free Exam Questions & Answers

A.
No fractional digits or time zone.

B.
12 fractional digits and no time zone.

C.
6 fractional digits and no time zone.

D.
12 fractional digits plus a time zone.

One Comment on “which attributes?

  1. db2man says:

    C)

    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0008474.html

    Timestamp
    A timestamp is a six or seven-part value (year, month, day, hour, minute, second, and optional fractional seconds) designating a date and time as defined in the previous sections, except that the time could also include an additional part designating a fraction of a second. The number of digits in the fractional seconds is specified using an attribute in the range from 0 to 12 with a default of 6.




    0



    0

Leave a Reply