Q. The storage size in bytes required for the MEDIUMINT datatype is ___________

View solution

Q. The size of the BIT type is ___________

View solution

Q. The REAL type is synonym for ___________

View solution

Q. The maximum number of elements allowed in SET() is ___________

View solution

Q. The number of binary string types among the following is ___________

BINARY, VARBINARY, BLOB, CHAR

View solution

Q. The maximum size in bytes of a row in MySQL is __________

View solution

Q. MEMORY tables do not support BLOB and TEXT indexes.

View solution

Q. MySQL works with spatial values in 3 formats.

View solution

Q. By default, MySQL clips out of range numeric values to the nearest fit value.

View solution

Q. For which type are illegal values converted to the appropriate ‘zero’ value?

View solution

Q. What is the command to see the warning messages?

View solution

Q. The SQL mode to check for divide by zero error is ________________

View solution

Q. Which mode is used to turn on strict mode and all of the additional restrictions?

View solution

Q. Which mode is a shorthand for ‘both strict modes plus a bunch of other restrictions’?

View solution

Q. Which mode prevents MySQL to perform full checking of date parts?

View solution

Q. Which keyword suppresses errors?

View solution

Q. Which mode prevents entry of the ‘zero’ date value in strict mode?

View solution

Q. STRICT_ALL_TABLES turns on stricter checking of data values.

View solution

Q. Which column attribute provides unique numbers for identification?

View solution

Q. There can be only one column per table with the AUTO_INCREMENT attribute.

View solution