1.

Association between one or more MyISAM tables and the named key cache is set by _____________(a) BEGIN(b) CACHE INDEX(c) ALTER DATABASE(d) ALTER EVENTThe question was asked in exam.I'm obligated to ask this question of Compound Statement Syntax topic in chapter SQL Syntax of MySQL

Answer»

The correct choice is (b) CACHE INDEX

Easy explanation: ‘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.



Discussion

No Comment Found

Related InterviewSolutions