Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    61

    Unanswered: Has DB2 NUMERIC data type?

    Hi every one,

    A DB2 mock question:

    Given that table T1 needs to hold specific numeric values up to 99999.99 in column C1.
    Which of the following would be the most exact definition for C1?

    1. REAL
    2. INTEGER
    3. NUMERIC(7,2)
    4. DECIMAL(5,2)

    What's your answer?

    Thanks,

  2. #2
    Join Date
    Mar 2004
    Posts
    61
    Yes, there is NUMERIC. When a column is created with NUMRIC data type, it is changed to DECIMAL.

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by hiolgc
    Hi every one,

    A DB2 mock question:

    Given that table T1 needs to hold specific numeric values up to 99999.99 in column C1.
    Which of the following would be the most exact definition for C1?

    1. REAL
    2. INTEGER
    3. NUMERIC(7,2)
    4. DECIMAL(5,2)

    What's your answer?

    Thanks,
    Is this from a test or something?

    3.

    REAL rounds, INTEGER can't store decimals, and your (5,2) definition would only store up to 999.99
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •