In MySQL, the default size of the key buffer in MB is . . . . . . . .
A. 4
B. 8
C. 16
D. 32
Answer: Option B
Solution(By Examveda Team)
4: This is not the default size of the key buffer in MySQL. It is smaller than the default size.8: The default size of the key buffer in MySQL is 8 megabytes (MB). This means MySQL allocates 8 MB of memory for caching index blocks for MyISAM tables unless otherwise specified.
16: This is not the default size of the key buffer in MySQL. It is larger than the default size.
32: This is not the default size of the key buffer in MySQL. It is larger than the default size.
Therefore, the default size of the key buffer in MySQL is Option B: 8 megabytes (MB).
This Question Belongs to MySQL >> MySQL Miscellaneous
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion