Q. Which datatype is used for a fixed length binary string?

View solution

Q. Which datatype means a variable length non binary string?

View solution

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