Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 2

Which of the following statements are true of how access control is based?

In order to create an account where no username is needed for login, ...

Which of the following are important network factors for remote MySQL clients?

Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\G ************************** 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 it mean that the possible_keys column value is NULL?

Which of the following should be done to enable secure logging of events which may be needed for recovery operations and to track down security incidents?

Which of the following are reasons to be selective when granting the FILE privilege to accounts?

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

You have been granted SELECT, INSERT and DELETE privileges on the table city in the world database. You log in, and exercise all your privileges without any problems. While you are still connected and doing work, the administrator removes your DELETE privileges and informs you by mail that you can no longer delete from table city. Being skeptical, you decided to test your privileges and realize that you still have them all. What is are the most likely causes of this?

Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\G ************************** 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?

You need to allow the user 'joe'@'example.com' the privilege to create and alter stored routines in the world database, but you do not want that user to be able to change any table definitions. The user already has the required permissions to access table data in the database. Which of the following will achieve that?