Successful Guide students to pass any IT certification.Provide latest Exam Topics(dumpandruns).ITrenzheng(IT認證)提供專業的認證信息資料,分享最新的考試材料及內容提要,為幫助更多的人通過IT認證.技朮學習,技朮指導.
IT認證資訊分享： http://www.itrenzheng.hk/
IT認證證照考古題： http://www.mcse2008.com.cn/
1. Is the following statement true or false? The username you use to connect to MySQL must be the same
as the login used to access the operating system.
A. true
B. false
Answer: B
2. Which of the following statements are required to create a key cache of 4 MB, assign the MyISAM table
world.City to it and preload the index?
A. mysql> SET GLOBAL city_cache.key_buffer_size = 4194304;mysql> CACHE INDEX world.City IN
city_cache;mysql> LOAD INDEX INTO CACHE world.City;
B. mysql> ALTER TABLE world.city KEY_CACHE = 4194304;
C. mysql> CREATE CACHE FOR world.City SIZE = 4194304;
D. It is not possible to create a key cache for a specific MyISAM table, only the global key cache can be
used.
Answer: A
3. How can the SHOW PROCESSLIST command be helpful when optimizing queries?
A. It shows if a query is using an index or not.
B. It shows how the server processes a query.
C. If checked periodically, it can reveal queries that cause other queries to hang.
D. It shows the percentage of processing power that each query is using on a server.
Answer: C