V

Vinay • 28.75K Points
Instructor II 

Q. Which system variable controls the size of the table cache?

  • (A) table_cache
  • (B) libmysqlb
  • (C) open_cache
  • (D) cache_open
  • Correct Answer - Option(A)
  • Views: 15
  • Filed under category MySQL
Explanation by: Vinay 
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.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Suppose a stored function named PI() is written in the database 'sampdb'. How would it be called?

Q. The metadata log is . . . . . . . .

Q. If $a represents an array with numeric indices in PHP, the first element accessed by . . . . . . . .

Q. The best datatype for a column that is expected to store values up to 2 million is . . . . . . . .

Q. What will be the result of the following MySQL command? WHERE TITLE= ‘teller’ AND start_date < ’2007-01-01’

Q. MySQL supports shared-memory connections on Windows.

Q. What does the DELETE Statement do?

Q. The option which finds the startup options supported by the server through mysqld is . . . . . . . .

Q. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command? SELECT emp_id FROM person ORDER BY emp_id ASC;

Q. What is generally used as a synonym for CHARACTER SET?

Learn All MySQL MCQs

Question analytics