Which value will show an error when stored in float(4,2)?(a) 12.11(b) – InterviewSolution

InterviewSolution

1.	Which value will show an error when stored in float(4,2)?(a) 12.11(b) 13.1(c) 1.12(d) 123.44
Answer» Right answer is (d) 123.44 Easiest explanation: “Float(4,2)” cannot store more than 4 digits.

Discussion

No Comment Found

Related InterviewSolutions

What is data in a MySQL database organized into?(a) Objects(b) Tables(c) Networks(d) File systems
The datatype for single precision floating point number is ____________(a) FLOAT(b) DOUBLE(c) INT(d) BIGINT
Which of these values is not valid as an AUTO_INCREMENT value?(a) 0(b) 1(c) 2(d) 3
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________(a) MEDIUMINT SIGNED(b) MEDIUMINT UNSIGNED(c) SMALLINT SIGNED(d) SMALLINT UNSIGNED
INT3 maps to MySQL type _____________(a) TINYINT(b) SMALLINT(c) MEDIUMINT(d) BIGINT
INT2 maps to MySQL type _____________(a) TINYINT(b) SMALLINT(c) MEDIUMINT(d) BIGINT
Which procedure parameter enables the caller to pass in a value and get back a value?(a) IN(b) OUT(c) INOUT(d) GETINOUT
The hub of a MySQL installation is ______________(a) mysqla(b) mysqlb(c) mysqlc(d) mysqld
Which script initializes the data directory during installation?(a) mysql_install_db(b) mysql_install_dbm(c) mysql_init_db(d) mysql_init_dbm
The SQL mode to check for divide by zero error is ________________(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) ERROR_DIVIDE_BY_ZERO(d) ERROR_WHEN_DIVIDE_BY_ZERO