ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

What will be the storage pattern for "float(4,2)" in Mysql?

Answer & Solution
Correct Answer: Option A
In MySQL, the syntax "float(4,2)" indicates a floating-point number with a total of 4 digits, with 2 digits to the left of the decimal point and 2 digits to the right of the decimal point.
The first parameter (4) specifies the total number of digits in the number, and the second parameter (2) specifies the number of digits after the decimal point.
Therefore, the storage pattern for "float(4,2)" in MySQL is as described in Option A.
Option B, Total of six digits, is incorrect because "float(4,2)" specifies a total of four digits, not six.
Option C, Total of four digits, not distributed uniformly, is incorrect because the digits are distributed uniformly, with two digits on each side of the decimal point.
Option D, None of the mentioned, is incorrect because Option A accurately describes the storage pattern for "float(4,2)" in MySQL.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.