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
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
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
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.
4. Which of these is the metadata log?
a) error log
b) ddl log
c) binary log
d) relay log
View Answer
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
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
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.
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
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.
8. Which of these is faster when accessing data?
memory, disk
a) memory
b) disk
c) same speed
d) machine dependent
View Answer
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
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
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.
- Check MySQL Books
- Apply for Programming Internship
- Practice Programming MCQs
- Check Information Technology Books