MySQL Database Multiple choice Questions and Answers-MySQL Administration

11.	Multiple MySQL servers cannot be run on the same machine.
a.	True
b.	False
c.	May be True or False
d.	Can't say

Discuss

Answer: (a).True

12.	The log in which data changes received from a replication master server are written are ______________
a.	error log
b.	general query log
c.	binary log
d.	relay log

Discuss

Answer: (d).relay log

13.	Which of these is the metadata log?
a.	error log
b.	ddl log
c.	binary log
d.	relay log

Discuss

Answer: (b).ddl log

14.	The max_binlog_cache_size system variable has default size ______________
a.	1 GB
b.	2 GB
c.	4 GB
d.	8 GB

Discuss

Answer: (c).4 GB

15.	What has a higher priority? writes, reads
a.	writes
b.	reads
c.	same priority
d.	machine dependent

Discuss

Answer: (a).writes

16.	The default scheduling property of MySQL is implemented by how many of these? MyISAM, MERGE, MEMORY
a.	0
b.	1
c.	2
d.	3

Discuss

Answer: (d).3

17.	Which of these is faster when accessing data? memory, disk
a.	memory
b.	disk
c.	same speed
d.	machine dependent

Discuss

Answer: (a).memory

18.	The system variable controls the size of the table cache _________________
a.	table_cache
b.	cache_table
c.	open_cache
d.	cache_open

Discuss

Answer: (a).table_cache

19.	Which of these exports table definitions and contents?
a.	mysqldump
b.	mysqladmin
c.	mysqlimport
d.	mysqlexport

Discuss

Answer: (a).mysqldump

20.	MySQL uses security based on ACL which stands for ______________
a.	Access Control Language
b.	Access Control Lists
c.	Automatic Control Lists
d.	Automatic Control Language

Discuss

Answer: (b).Access Control Lists