adplus-dvertising
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

Page 2 of 18