Which among the following is the correct representation of "float(1,1)"?
A. Total of 1 digit
B. Total of 2 digit
C. Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal
D. None of the mentioned
Answer: Option C
Solution (By Examveda Team)
In MySQL, the syntax "float(1,1)" represents a floating-point number with a total of 2 digits.The first parameter (1) specifies the total number of digits in the number.
The second parameter (1) specifies the number of digits after the decimal point.
Therefore, "float(1,1)" allows for a total of 2 digits, with one digit before the decimal point and one digit after it.
Option A, Total of 1 digit, is incorrect because "float(1,1)" allows for a total of 2 digits, not just 1.
Option B, Total of 2 digit, is incorrect because it lacks specificity regarding the position of the decimal point.
Option D, None of the mentioned, is incorrect because Option C accurately represents the definition of "float(1,1)" in MySQL.
This Question Belongs to MySQL >> MySQL Miscellaneous
Join The Discussion