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