Q. In which directory are the DBI scripts located?

View solution

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

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. In which context is the privilege ‘CREATE TABLESPACE’ applied?

View solution

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

View solution

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

View solution

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