Want to pass your MySQL 5.0 Database Administrator Certified Professional Exam, Part II 1Z0-874 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which of the following best describes the order in which MySQL considers host names and user names when a client attempts connection?
A. Hostnames then usernames
B. Usernames then hostnames
C. Both hostnames and usernames are checked concurrently.
In regards to security, which of the following statements are true?
A. mysqld should not be run as root or administrator.
B. mysqld should be run as root or administrator.
C. The user owning the server process should own all files and directories to which the server may write.
D. The root or admininistrator users should own all files related to the server process
What should you do in order to enhance the security of a standard MySQL installation on Unix- type operating systems?
A. Disable the mysql_access program
B. Run the mysql_secure_installation script
C. Nothing; by default the security level of a MySQL installation is very high