Question

All of the following values can be stored in a column that’s defined as decimal(6,2), except

Answer 1

Step-by-step explanation:

A value that exceeds 6 digits in total, including the digits before and after the decimal point, cannot be stored in a column defined as decimal(6,2). For example, 123456.12 could be stored in this column, but 123456.123 could not be stored because it has 7 digits in total.

Here are some examples of values that could and could not be stored in a column defined as decimal(6,2):

123.45 (can be stored)

123456.12 (can be stored)

123456.123 (cannot be stored)

9999.99 (can be stored)

999999.99 (cannot be stored)