12. | The log in which data changes received from a replication master server are written are ______________ |
Discuss |
Answer: (d).relay log
|
13. | Which of these is the metadata log? |
Discuss |
Answer: (b).ddl log
|
14. | The max_binlog_cache_size system variable has default size ______________ |
Discuss |
Answer: (c).4 GB
|
15. | What has a higher priority?
writes, reads |
Discuss |
Answer: (a).writes
|
16. | The default scheduling property of MySQL is implemented by how many of these?
MyISAM, MERGE, MEMORY |
Discuss |
Answer: (d).3
|
17. | Which of these is faster when accessing data?
memory, disk |
Discuss |
Answer: (a).memory
|
18. | The system variable controls the size of the table cache _________________ |
Discuss |
Answer: (a).table_cache
|
19. | Which of these exports table definitions and contents? |
Discuss |
Answer: (a).mysqldump
|
20. | MySQL uses security based on ACL which stands for ______________ |
Discuss |
Answer: (b).Access Control Lists
|