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

1. Which of the following statements are true?

A) A MERGE table cannot be used with compressed tables.
B) A MERGE table may span across compressed and uncompressed tables.
C) A MERGE table can only be a collection of either compressed or uncompressed tables.

2. 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

3. Which of the following are true regarding the usage of the IDENTIFIED BY clause in the GRANT statement used to create a new user account? (Choose two)

A) The IDENTIFIED BY clause is always optional
B) The IDENTIFIED BY clause may be mandatory depending on the current SQL mode
C) The IDENTIFIED BY clause specifies an alternate user name for the account
D) The IDENTIFIED BY clause specifies the password to be used with the account
E) The IDENTIFIED BY clause is always mandatory
F) There is no IDENTIFIED BY clause for the GRANT statement

4. Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Code = 'CAN' *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: Which of the following best describes the meaning of the value of the type column?

A) The table has exactly one row.
B) Only one row of all its rows need to be read.
C) Several rows may be read from the table.

5. What type of resource limitations may be placed on a user account with the GRANT statement? (Choose four)

A) The number of updates per hour an account is allowed to issue
B) The number of times per hour that an account is allowed to connect to the server
C) The number of queries per hour an account is allowed to issue
D) MySQL does not have provisions for limiting resource usage
E) The maximum number of simultaneous connections an account can have
F) Resource limits can only be specified globally, not per-account

質問と回答：