Question

Using the Number data type for the Country Population field in a database, with characteristics of the lowest data value starting at over 1 million and the highest at 2 billion, set the Field Size Property to _____.

1) Byte
2) Integer
3) Long Integer
4) Single

Answer 1

For handling the population range of over 1 million to 2 billion in a database, the Field Size Property should be set to Long Integer, as it can store large numeric values within the given range.

Step-by-step explanation:

When selecting the Field Size Property for a Country Population field in a database, we need to consider the range of values that will be stored. In this case, the population ranges from over 1 million to 2 billion. The correct data type to represent numbers in this range is Long Integer, which in many database systems can store values from -2,147,483,648 to 2,147,483,647. Therefore, setting the Field Size Property to Long Integer will accommodate populations up to 2 billion.