Question 11

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid for why one of the users is unable to connect to the database?
  • Question 12

    Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?
  • Question 13

    MySQL is installed on a Linux server and has this configuration:
    [mysqld]
    user=mysql
    datadir=/data/mysql/
    As the 'root' user, you change the datadir location by executing:
    shell> cp -R /var/lib/mysql /data/mysql/
    shell> chown -R mysql /data/mysql
    What is the purpose of changing ownership of datadirto the 'mysql' user?
  • Question 14

    You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)
  • Question 15

    You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis set to DATABASE.

    Assume that all instruments and consumers are enabled and all threads are instrumented.
    Which two facts can be concluded from the given output? (Choose two.)