MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II 認定 1Z0-874 試験問題:
1. Which of the following best describes the purpose of the join buffer, and when should you increase the size of it? (Choose three)
A) The join buffer is set per-connection.
B) The value should be increased if the client has the tendency to perform complex joins.
C) The join buffer is used to process joins.
D) The join buffer is global and can only be changed by restarting the server.
E) The value should be increased if the client performs a lot of SELECT operations.
F) The join buffer is used to process sorts when complex joins are being performed.
2. Is it ever safe to start the MySQL server as root?
A) No because you can not make it switch the effective user if started as root.
B) No it is never safe to start it as root.
C) Yes provided you make it switch the effective user to mysql.
D) Yes it is always safe to start it as root.
3. Should all queries in the slow query log be optimized? (Choose two)
A) Yes, unless they depend on tables in the mysql database
B) No; A query may have been entered into the slow query log because other, slow queries, prevented it from executing quickly
C) No; Only the very slowest queries should be optimized
D) Yes.
E) No; Queries that are run rarely are probably not worth the effort of optimization
4. Which of the following statements are true regarding the slow query log? (Choose four)
A) The slow query log can be switched on with the log_slow_queries option.
B) You can use the SHOW SLOW QUERIES statement to display all entries in the slow queries log.
C) The slow query log contains queries that don't utilize any index.
D) You can use the mysqldumpslow command line tool to summarize the content of the slow query log.
E) The slow query log will contain queries that take more than 10 seconds.
F) The slow query log is always enabled.
G) To have the slow query log contain queries that don't utilize any index, the log-queriesnotusingindexes option needs to be set.
H) The slow query log will contain queries that take more seconds than configured in the long_query_time option.
5. Which of the following best describes the purpose of the InnoDB buffer pool?
A) It is the amount of buffers available during a transaction.
B) It caches data and index information for InnoDB tables.
C) It holds changes made during a transaction before they are written to the log.
質問と回答：
| 質問 # 1 正解： A、B、C | 質問 # 2 正解： C | 質問 # 3 正解： B、E | 質問 # 4 正解： A、D、G、H | 質問 # 5 正解： B |
967 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
