MySQL Questions and Answers – General MySQL Administration

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “General MySQL Administration”.

1. The MySQL server is highly configurable.
a) True
b) False
View Answer

Answer: a
Explanation: The MySQL server is highly configurable. Some of the operational characteristics that you can control include which storage engines the server supports, the default character set, and its default time zone.

2. Multiple MySQL servers cannot be run on the same machine.
a) True
b) False
View Answer

Answer: a
Explanation: It is useful to run multiple servers on the same machine under certain circumstances. A new MySQL release can also be tested while leaving the current production server in place.

3. 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
View Answer

Answer: d
Explanation: The Relay Log has the data changes received from a replication master server written in it. The problems encountered during the starting, running or stopping of ‘mysqld’ are written in error log.
advertisement
advertisement

4. Which of these is the metadata log?
a) error log
b) ddl log
c) binary log
d) relay log
View Answer

Answer: b
Explanation: The DDL log is also known as the metadata log. The metadata operations performed by the DDL statements. The Relay Log has the data changes received from a replication master server written in it.

5. The max_binlog_cache_size system variable has default size ______________
a) 1 GB
b) 2 GB
c) 4 GB
d) 8 GB
View Answer

Answer: c
Explanation: The max_binlog_cache_size system variable can be used to restrict the total size used to cache a multiple-statement transaction. If transaction is larger than this it fails and rolls back.

6. What has a higher priority?

writes, reads

a) writes
b) reads
c) same priority
d) machine dependent
View Answer

Answer: a
Explanation: A client performing an operation that modifies a table is a writer and the client that performs a retrieval from the table is a reader. The writes have higher priority than reads.
advertisement

7. The default scheduling property of MySQL is implemented by how many of these?

MyISAM, MERGE, MEMORY

a) 0
b) 1
c) 2
d) 3
View Answer

Answer: d
Explanation: The MyISAM, MERGE and the MEMORY storage engines implement the default scheduling policy of MySQL with the help of the table locks. Whenever a client accesses a table a lock for it must be acquired first.
advertisement

8. Which of these is faster when accessing data?

memory, disk

a) memory
b) disk
c) same speed
d) machine dependent
View Answer

Answer: a
Explanation: In MySQL, the administrators have more privileges since they have more control of the MySQL server or the machine on which it runs. Accessing data in memory is faster than from disk.

9. The system variable controls the size of the table cache _________________
a) table_cache
b) cache_table
c) open_cache
d) cache_open
View Answer

Answer: a
Explanation: In MySQL, when the server opens table files it keeps them open to minimize the number of file-opening operations. It maintains information about open files in the table cache.

10. Which of these exports table definitions and contents?
a) mysqldump
b) mysqladmin
c) mysqlimport
d) mysqlexport
View Answer

Answer: a
Explanation: In MySQL, some distributions include a set of some client programs. ‘mysqldump’ exports the table definitions and the contents. ‘mysqladmin’ performs adminisitrative tasks.

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.