Q. What is the return value from operations returning a row count?

View solution

Q. Functions are called and pointers to structures are used while using DBI API.

View solution

Q. The mode of search in which the search string is parsed into words and the search looks for rows is ________________

View solution

Q. What is the hub of a MySQL installation?

View solution

Q. The place where the server stores its databases and status files are called the data directory.

View solution

Q. Which program copies the databases from one server to another?

View solution

Q. To use ‘mysqldbcopy’ which privileges are required on the source server?

View solution

Q. The program that performs logical backups is _____________

View solution

Q. In ‘mysqldump’ which option is used to make all tables in the destination databases to use a different storage engine?

View solution

Q. Which function returns reference to hash of row values?

View solution

Q. The function ‘fetchrow_hashref()’ returns reference to hash of row values keyed by ______________

View solution

Q. Which function returns reference to array of row values?

View solution

Q. The MySQL server is poorly configurable.

View solution

Q. Multiple MySQL servers can be easily run on the same machine.

View solution

Q. Which is the log in which data changes received from a replication master server are written?

View solution

Q. CHECK TABLE works with how many of the following?

MyISAM, ARCHIVE, CSV

View solution

Q. REPAIR TABLE works with how many of the following?

MyISAM, ARCHIVE, CSV

View solution

Q. Which myisamchk variable represents the size of buffer used to hold index blocks?

View solution

Q. Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine?

View solution

Q. With only MyISAM tables, how many of the following are for use?

mysql, mysqladmin, mysqldump, mysqlisamchk

View solution