Question

What sets up an association between one or more MyISAM tables and the named key cache?

(a) BEGIN

(b) CACHE INDEX

(c) ALTER DATABASE

(d) ALTER EVENT

This question was posed to me in semester exam.

My query is from SQL Statement Syntax (Non-Compound Statements) in division SQL Syntax of MySQL

Answer 1

Right choice is (b) CACHE INDEX

The best I can explain: ‘CACHE INDEX’ sets up an association between one or more MyISAM tables and the named key cache which must already exist. The INDEX privilege is needed for each table named in the statement.