1Z0-874：最新的MYSQL認證1Z0-874考題，MySQL 5.0 Database Administrator Certified Professional Exam, Part II認證

問題1
Consider the following:
mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'
*************************** 1. row ***************************
id: 1
select_type: SIMPLE table: City
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 4079
Extra: Using where
What does the possible_keys column in this output denote?

A. Whether there are any indexes on the table(s) you are querying.

B. If there are any indexes you may be able to use.

C. Whether you are using any indexes in your query.

D. If it is possible for you to include any indexes in your query.

正確答案: B

問題2
Which of the following is true of the table cache if you mainly run simple queries on many tables?

A. The table cache should be increased.

B. The table cache should not be changed.

C. The table cache should be decreased.

正確答案: A

問題3
How can stored routines be used to check for constraints or legality

A. They cannot be used to check for constraints or legality of data.

B. They can check and only perform an action if the incoming values match a specified value.

C. They can make use of the VALIDATE DEFINER setting.

正確答案: B

問題4
Granting access to the mysql database...

A. Should be done for anyone needing to create views

B. Should always be done for all users.

C. Should only be done on administrator accounts.

D. Should never be done for any users.

正確答案: C

問題5
Which of the following best describes the purpose of the max_allowed_packet parmeter, and when it is set? (Choose two)

A. The max_allowed_packet parameter is global and is only set by shutting down the server.

B. The max_allowed_packet parameter is set per-connection.

C. The max_allowed_packet parameter is used to control the buffer that is used for communication between the server and the client.

D. The max_allowed_packet parameter is used to control the size of the dataset that is sent to the client.

正確答案: B,C

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

A. The maximum number of simultaneous connections an account can have

B. Resource limits can only be specified globally, not per-account

C. The number of queries per hour an account is allowed to issue

D. The number of times per hour that an account is allowed to connect to the server

E. MySQL does not have provisions for limiting resource usage

F. The number of updates per hour an account is allowed to issue

正確答案: A,C,D,F

問題7
Which of the following are methods to improve performance? (Choose two)

A. Spreading single tables to different disks pointed to by a symbolic link.

B. Spreading whole databases to different disks pointed to by a symbolic link.

C. Moving the MySQL utilities such as mysqladmin to different disks pointed to by a symbolic link.

D. Moving less needed parts of the MySQL install such as the documentation or the test files to different disks pointed to by a symbolic link.

正確答案: A,B

問題8
The password for the existing user 'kofi'@'agric.comp1.com' must be changed to "Sakila". Which of the following will do that?

A. SET PASSWORD 'Sakila' FOR 'kofi'@'agric.comp1.com'

B. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = 'Sakila'

C. SET PASSWORD('Sakila') FOR 'kofi'@'agric.comp1.com'

D. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = PASSWORD('Sakila')

正確答案: D

問題9
How can the SHOW PROCESSLIST command be helpful when optimizing queries?

A. It shows how the server processes a query.

B. It shows the percentage of processing power that each query is using on a server.

C. It shows if a query is using an index or not.

D. If checked periodically, it can reveal a queries that causes other queries to hang.

正確答案: D

問題10
Which of the following statements best describe the indexes supported by the MEMORY storage engine, and their general characteristics?

A. MEMORY tables only support BTREE which provide better performance with non-unique index values and other comparison operators.

B. MEMORY tables support HASH indexes which provide fast lookups that use a unique index, and BTREE indexes which provide better performance with non-unique index values and other comparison operators.

C. MEMORY tables only support HASH indexes which provide fast lookups that use a unique index.

D. MEMORY tables support HASH indexes which provide better performance with non-unique index values and other comparison operators, and BTREE indexes which provide fast lookups that use a unique index.

正確答案: B

最新的MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II - 1Z0-874免費考試真題

專業認證

品質保證

輕松通過

免費試用