A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?

The correct answer is C. Text. A telephone number, despite being composed of digits, is not used for calculations and often includes formatting characters such as hyphens (-). Therefore, the most appropriate data type for a telephone number is Text (or VARCHAR in SQL databases), which can accommodate various…

Data Concepts and Environments

Question

Options

ABoolean
BDate
CText
DNumber

How the community answered

(27 responses)

B
4% (1)
C
93% (25)
D
4% (1)

Explanation

A telephone number, despite being composed of digits, is not used for calculations and often includes formatting characters such as hyphens (-). Therefore, the most appropriate data type for a telephone number is Text (or VARCHAR in SQL databases), which can accommodate various formats and lengths, and preserve leading zeros that might be present in some phone numbers. Storing phone numbers as numeric data types would strip away any formatting and could lead to the loss of significant leading digits (like zeros in international numbers).

Topics

#data types#text data#data representation#phone number formatting

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice