MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II 認定 1Z0-874 試験問題:

1. It is important to analyze queries that involve joins with EXPLAIN because...

A) Joins are more prone to mistakes.
B) Joins have the potential to cause more server processing if not defined correctly.
C) Using EXPLAIN before executing the query helps the server prepare the statements used.

2. Which of the following are general features of replication? (Choose three)

A) Allows the databases on one server to be made available on another server.
B) Multiple copies are available in case a server crashes or goes offline.
C) Provides complete redundancy and high availability at all times.
D) Can be used to distribute the load caused by servicing many clients.

3. In the following query, the Population column is indexed: mysql> EXPLAIN SELECT Name -> FROM Country -> WHERE Code LIKE '%B%' AND Population > 10000 *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: ALL possible_keys: i_pop key: NULL key_len: NULL ref: NULL rows: 239 Extra: Using where
Which of the following best describes how to deal with the key value of the EXPLAIN output? (Choose two)

A) Use FORCE INDEX.
B) Use USE POSSIBLE_KEY
C) Use USE INDEX.
D) Use FORCE KEY

4. Why should log files be secured against reading by non-authorized users? (Choose two)

A) The server may be prevented from writing to the log file
B) Data values may be read
C) Usernames and passwords could be revealed.
D) Unauthorized users may alter the log contents.

5. Which of the following best describes what MASTER_LOG_FILE and MASTER_LOG_POS provides? (Choose two)

A) The file to log replication actions to.
B) The position in the masters binary log in which to start replication.
C) The masters binary log name used for replication.
D) The path of the log file.

質問と回答：