26.
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
- Report
Answer : [B]
27.
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
- Report
Answer : [B]
28.
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 inmysqld 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 restartunexpectedly and not due to normal startup and shutdown.
- Answer
- Report
Answer : [D]
29.
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
- Report
Answer : [A, C]
30.
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.
- 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
- Report
Answer : [A, B, D,E]
|
|
||||||||||||||||||||||||||||
