Question

What is the maximum non zero values for DOUBLE?

(a) ±1.7976931348623157E+307

(b) ±1.7976931348623157E+308

(c) ±1.7976931348623157E+306

(d) ±1.7976931348623157E+305

This question was posed to me in a job interview.

This interesting question is from Putting Perl DBI to Work topic in portion MySQL Programs Using Perl DBI and PHP of MySQL

Answer 1

Correct option is (b) ±1.7976931348623157E+308

To explain I would say: In MySQL, all the datatypes have their own ranges. Data types give an idea of the kind of values and the ranges that a variable is allowed to store. The maximum non zero value for DOUBLE is ±1.7976931348623157E+308.