Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: MySQL 006-002
Title
: Certified MySQL 5.0 DBA
Part II
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Can multi-column FULLTEXT indexes be used?
If so, when?
A. No, they can not be used.
B. Yes, they should be used to search multiple columns simultaneously.
C. Yes, they can be used to search either one or all of the indexed columns.
Answer: B
2. What kind of replication is supported by the MySQL server?
A. Multiple-master replication
B. Master to slave replication
C. Single file based clustering
D. MySQL doesn't support replication
Answer: B
3. When performing diagnostic functions on a server should excessive start and stop messages be looked
for in the error log, and why?
A. No, start and stop messages are of no relevance to diagnostics.
B. Yes, because there is a bug in mysqld that can cause multiple start and stop messages to be inserted in
the log.
C. No, because they will not provide any information as to what is wrong.
D. Yes, because they can indicate that there is something causing the server to restart unexpectedly and
not due to normal startup and shutdown.
Answer: D
4. Which of the following best describe the effects on performance for the dynamic-row format for MyISAM
has?
A. Retrievals are more complex and slower.
B. Retrievals are less complex and are faster.
C. Rows generally take up less disk space than fixed-row format.
D. Rows generally take up more disk space than fixed-row format.
Answer: AC
5. Which of the following optimizations could be made based on data collected in the slow query log?
A. Tune server parameters.
B. Change the storage engines in use.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
C. Make changes to the network infrastructure.
D. Rewrite queries to perform more efficiently.
E. Normalize data or add indexes to the tables that the queries use.
Answer