MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II Sample Questions:

1. As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement: GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' Which of the following best describe the effects of issuing this statement?

A) There is not enough information provided to determine the outcome of executing that statement.
B) An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.
C) Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.
D) The account is not created, as you must always specify a password for new users
E) Since no password is specified, the account is created with an empty password that must be changed by the user on first login

2. Does max_connections have an affect on the number of slaves that may connect to a master?

A) Yes, because if the server has too many connections, it may slow the slaves down.
B) No, because slaves do not use the same type of connection as a regular client.
C) Yes, because each slave is effectively a connected user.
D) No, because slaves are not really clients.

3. Given the result of the following query:
mysql> SELECT Host, User FROM mysql.user WHERE User='joe';
+-------------+------+
| Host | User |
+-------------+------+ | % | joe |
| example.com | joe |
+-------------+------+
2 rows in set (0.00 sec)
A client connection is established with the username joe from the host example.com. Assuming that the login is successful, which of the entries shown in the mysql.user table are used to authenticate the client connection for subsequent query executions, and why?

A) For every query, the 'joe'@'example.com' account is checked first. If that does not have the proper permissions, 'joe'@'%' will be used as MySQL will check all relevant accounts, with the most specific hostname first.
B) The 'joe'@'%' account is used for all authentication, as MySQL will always use the most general host name possible.
C) For every query, the 'joe'@'%' account is checked first. If that does not have the proper permissions, 'joe'@'example.com' will be used as MySQL will check all relevant accounts, with the most general hostname first.
D) The 'joe'@'example.com' account is used for all authentication, as MySQL will always use the most specific hostname possible.

4. When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server?

A) They may increase the amount of data exchanged.
B) They can help reduce the amount of data exchanged.
C) They have no effect on the amount of data exchanged.

5. Which of the following are reasons you would want to normalize your data? (Choose three)

A) It is the only way to make your data internationalized.
B) It makes data access more flexible.
C) It makes backups more efficient.
D) It helps eliminate possible data inconsistencies.
E) It removes redundant data.

Solutions: