Q. Which of these types store the longest length of strings?

View solution

Q. AUTO_INCREMENT columns must be NOT NULL.

View solution

Q. Which of these values is not valid as an AUTO_INCREMENT value?

View solution

Q. If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________

View solution

Q. INT2 maps to MySQL type _____________

View solution

Q. INT3 maps to MySQL type _____________

View solution

Q. Which of these is not an exact numeric type?

View solution

Q. How many of the following do not support ‘BIT’ data type?

MyISAM, MEMORY, NDB

View solution

Q. The statement that suspends the replication related activity of the slave server is _____________

View solution

Q. The minimum value stored by signed TINYINT is _____________

View solution

Q. MySQL uses security based on ACL. What does it stand for?

View solution

Q. On Unix, ‘mysql’ client writes a record of executed statements to a history file.

View solution

Q. A password applies locally to an account.

View solution

Q. If $a represents an array with numeric indices in PHP, the first element accessed by ______________

View solution

Q. The operator used in PHP to access property of an object is ________________

View solution

Q. The maximum value that can be specified to the size of VARCHAR is _____________

View solution

Q. The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________

View solution

Q. Which mode does not remove trailing spaces when CHAR values are retrieved?

View solution

Q. What is the minimum value stored by signed TINYINT?

View solution

Q. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

View solution