You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?

Is it true that binary backups always take less space than text backups?

Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?