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

Q. The AUTO_INCREMENT sequences normally begin at __________

View solution

Q. The value of recently generated sequence number can be obtained by ____________

View solution

Q. When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________

View solution

Q. The ‘LAST_INSERT_ID()’ is tied only to the ‘AUTO_INCREMENT’ values generated during the current connection to the server.

View solution