Which system variable controls the size of the table cache?
A. table_cache
B. cache_table
C. open_cache
D. cache_open
Answer: Option A
Solution(By Examveda Team)
table_cache: This is the correct option. The table_cache system variable in MySQL controls the size of the table cache. It determines the maximum number of open tables that MySQL keeps cached in memory for quick access.cache_table: This option is incorrect. "cache_table" is not a recognized system variable in MySQL for controlling the size of the table cache.
open_cache: This option is incorrect. "open_cache" is not a recognized system variable in MySQL for controlling the size of the table cache.
cache_open: This option is incorrect. "cache_open" is not a recognized system variable in MySQL for controlling the size of the table cache.
Therefore, the system variable that controls the size of the table cache in MySQL is Option A: table_cache.
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