Oracle MySQL 5.7 Database Administrator — Question 9

Which three allocate memory per thread in MySQL? (Choose three.)

Answer options

• A. query cache
• B. thread cache
• C. read buffer
• D. internal temporary table
• E. sort buffer
• F. InnoDB buffer pool instance

Correct answer: C, E, F

Explanation

The correct answers, C, E, and F, are all memory allocations that occur per thread in MySQL. The read buffer, sort buffer, and InnoDB buffer pool instance are specifically designed to handle thread-specific operations, whereas the query cache and thread cache do not allocate memory on a per-thread basis.