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

Q. What is used to reload a delimited text data file?

View solution

Q. Replication does not enable data from one MySQL database server to be copied to one or more MySQL database servers.

View solution

Q. What is SBR replication?

View solution