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

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

View solution

Q. What is the output from PHP?

View solution

Q. What are PHP variables preceded by?

View solution

Q. Which data type is best suited to store currency values?

View solution

Q. Which program converts binary log files to statements in text form?

View solution