Question

Which of the following is NOT true when determining the field size?

1) Whenever you use a Text data type, you should determine the minimum number of text characters that can exist in the field.
2) Limiting the field size will limit errors in the data.
3) If you need more than 255 characters, use a Long Text data type.
4) You should use the number size that best suits your needs.

Answer 1

Limiting the field size too much can lead to truncation errors, where data is cut off or lost.

Step-by-step explanation:

The correct answer is 2) Limiting the field size will limit errors in the data. When determining the field size, it is important to consider the range of values that will be stored in the field. However, limiting the field size too much can lead to truncation errors, where data is cut off or lost. Therefore, it is important to choose a field size that is large enough to accommodate all possible values without excessive waste of storage space, while also considering the overall data storage requirements.