You have the following in your my.cnf configuration file:
[ mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

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

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

Which three are key advantages of standard MySQL replication?

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)