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

Q. Which is the library file that contains various portability macros and definitions?

View solution

Q. Which is the header that should be included first?

View solution

Q. Which of these has special automatic update behavior?

View solution

Q. To disallow zero month or day parts in dates, the option used is _____________

View solution