Question 66

You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is 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.)
  • Question 67

    One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
    The colleague instant messages you this command:
    mysql> SET SESSION max_connections = 200;
    Why does the command fail?
  • Question 68

    These details are shown when logged in to an account:

    Which set of statements would match the accounts shown?
    mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
  • Question 69

    Which two are considered good security practices when using passwords? (Choose two.)
  • Question 70

    Examine the mydata table and SELECT statements:

    You issue:
    mysql> begin;
    mysql> update mydata set a=0 where b=3;
    How many rows are now protected by locks with the default InnoDB configuration?