Q. Which data and time datatype stores time value in ‘hh:mm:ss’ format?

View solution

Q. Which spatial datatype is used to store a curve?

View solution

Q. How many of the following attributes are allowed only for numeric types?

UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE

View solution

Q. A DEFAULT value cannot be supplied to spatial types.

View solution

Q. A DEFAULT value cannot be supplied to TEXT types.

View solution

Q. The datatype INT stores ___________

View solution

Q. The datatype SMALLINT stores ___________

View solution

Q. The maximum non zero value for FLOAT is ___________

View solution

Q. The maximum non zero values for DOUBLE is ___________

View solution

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