Home/ Questions/Q 352266
Next
In Process
Bijoy Virk
Asked: 2022-10-29T07:11:59+05:30 In:

If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________

(a) MEDIUMINT SIGNED

(b) MEDIUMINT UNSIGNED

(c) SMALLINT SIGNED

(d) SMALLINT UNSIGNED

If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________

(a) MEDIUMINT SIGNED

(b) MEDIUMINT UNSIGNED

(c) SMALLINT SIGNED

(d) SMALLINT UNSIGNED
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. The correct choice is (b) MEDIUMINT UNSIGNED

    To elaborate: Since the range starts from the positive value 1, it is best to keep the datatype as UNSIGNED. The maximum value is of the order of 10^5, so a MEDIUMINT datatype is well suited.

    • 0