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

Q. In which context is the privilege ‘CREATE TABLESPACE’ applied?

View solution

Q. How many of the following languages can interface to bind to the C API of MySQL?

Perl, PHP, Python

View solution

Q. PHP scripts are located in the web client document tree.

View solution

Q. In which directory are the DBI scripts located?

View solution

Q. Which is the stored program associated with a schedule?

View solution