Q47
In MySQL, the default size of the key buffer in MB is . . . . . . . .
A.
4
B.
8
AnswerC.
16
D.
32
Answer: Option B
Solution
Answer: Option B
Solution:
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).