The maximum size in bytes of a row in MySQL is __________(a) 65534(b) – InterviewSolution

InterviewSolution

1.	The maximum size in bytes of a row in MySQL is __________(a) 65534(b) 65535(c) 65536(d) 65537
Answer» Right choice is (b) 65535 Best explanation: The allowable range of M for VARCHAR(M) syntactically is 1 to 65535, but the effective number of the maximum characters is less than 65535 since MySQL has a maximum row size of 65,535 bytes.

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