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

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

View solution

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

View solution

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

View solution

Q. The MySQL server is not configurable.

View solution

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

View solution

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

View solution

Q. The metadata log is _______________

View solution

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

View solution

Q. The higher priority is ______________

writes, reads

View solution

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

View solution

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

View solution

Q. Which statement suspends the replication related activity of the slave server?

View solution

Q. MySQL Enterprise Backup records details of each backup in _____________

View solution