Make your own Quiz

MYSQL

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

mysqldump

mysqllog

mysqlbin

mysqlbinlog

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

copy-back-and-apply-log

apply-log-and-copy-back

copy-log-and-apply-back

apply-back-and-copy-log

3. The MySQL server is not configurable.

True

False

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

error log

general query log

binary log

relay log

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

1 GB

2 GB

4 GB

8 GB

6. The higher priority is ______________

writes, reads

writes

reads

same priority

machine dependent

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

key_buffer_size

read_buffer_size

sort_buffer_size

write_buffer_size

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

history_backup

backup_history

backlog_history

history_backlog

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

True

False

10. The metadata log is _______________

error log

ddl log

binary log

relay log

0

{"name":"MYSQL", "url":"https://www.quiz-maker.com/QS23IXD","txt":"1. Which program converts binary log files to statements in text form?, 2. The ‘mysqlbackup’ command to perform a restore operation is _____________, 3. The MySQL server is not configurable.","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

Powered by

Powered by: Quiz Maker