Question

You are creating a field which will save data ranging from -1,598,632.153 to 1,598,632.153. What is the precision and scale?

a) Precision 11 Scale 3
b) Scale 11 Precision 3
c) Precision 10 Scale 3
d) Scale 10 Precision 3
e) Scale 12 Precision 3

Answer 1

The precision and scale of the field will determine the range and accuracy of the data that can be saved. In this case, the precision is 11 and the scale is 3.

Step-by-step explanation:

The precision and scale of the field will determine the range and accuracy of the data that can be saved.

In this case, the data ranges from -1,598,632.153 to 1,598,632.153. The precision is the total number of digits that can be stored, including both the integer and decimal parts of the number. The scale is the number of digits that can be stored after the decimal point.

Based on the range given, the correct answer is a) Precision 11 Scale 3. The precision is 11 because it includes the total number of digits in the range (-1,598,632.153 has 11 total digits) and the scale is 3 because it includes the number of digits after the decimal point (0.153 has 3 digits after the decimal point).