Q. Which statement on the master expires binary log files?

View solution

Q. The slave stores the CHANGE MASTER parameters in the file _____________

View solution

Q. The higher priority is ______________

writes, reads

View solution

Q. What is the default size of ‘max_binlog_cache_size’ system variable?

View solution

Q. The metadata log is _______________

View solution

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

View solution

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

View solution

Q. The MySQL server is not configurable.

View solution

Q. Where does MySQL Enterprise Backup record details of each backup?

View solution

Q. The myisamchk variable that represents the size of buffer used to hold index blocks is _____________

View solution

Q. The ‘mysqlbackup’ command to perform a restore operation is _____________

View solution

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

View solution

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

View solution

Q. What are PHP variables preceded by?

View solution

Q. What is the output from PHP?

View solution

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

View solution

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

mysql, mysqladmin, mysqldump, mysqlisamchk

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. Which myisamchk variable represents the size of buffer used to hold index blocks?

View solution

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

MyISAM, ARCHIVE, CSV

View solution