Asked by sonia umezurike on May 26, 2024
Verified
What data type should you assign to a field that stores postal codes?
A) Number
B) Address
C) Required
D) Short Text
Postal Codes
A series of letters, numbers, or both, assigned to different areas to facilitate mail sorting and delivery.
Short Text
A data type in database and software applications that is designed to hold small amounts of alphanumeric text, such as names or titles.
- Identify and select appropriate data types for fields in tables according to the data they will store.
Verified Answer
PS
parminder singhMay 31, 2024
Final Answer :
D
Explanation :
Postal codes typically contain a mix of numbers and letters, and can vary in length depending on the country. Therefore, the most appropriate data type to use for this field is Short Text, which allows for alphanumeric characters and variable length input.
Learning Objectives
- Identify and select appropriate data types for fields in tables according to the data they will store.