Home » MCQs » SQL MCQs » SQL Data Types MCQs

How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?

12. How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?

1. If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
2. If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
3. If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
4. If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().

Answer: D) If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE()

Explanation:

MySQL determines to use FLOAT or DOUBLE using the p parameter. If p comes between 0 to 24, the data type becomes FLOAT(). If p comes between 25 to 53, the data type becomes DOUBLE().