Asked by Brooke Thompson on May 09, 2024

verifed

Verified

What Field Size should you set for a State field that stores two-character state abbreviations?

A) 255
B) 5
C) 2
D) 0

Field Size

The maximum amount of data that can be stored in a database field, often measured in characters or bytes.

State Field

A data field specifically used for storing the state portion of an address or geographical information in databases and applications.

  • Master the technique of assigning properties including Default Value and Field Size within table fields.
verifed

Verified Answer

NG
Nushrut GhoorunMay 16, 2024
Final Answer :
C
Explanation :
A two-character state abbreviation can only hold two characters, so setting the field size to 2 would be sufficient to hold the necessary data without wasting space. Setting the field size any larger (such as to 255) would be unnecessary and wasteful. Setting the field size to 5 may accommodate potential future changes where state names may be longer, but it is not necessary for storing the current two-character state abbreviations. Setting the field size to 0 is not a valid option as it would not allow any data to be stored in the field.