InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
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 |
|
Answer» 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. |
|