MySQL 5.7 Database Administrator: 1Z0-888

What is the order of tables shown in an EXPLAIN output?

A. It lists tables from the smallest to the largest.

B. It lists tables in the order in which their data will be read.

C. It lists tables from the most optimized to the least optimized.

D. It lists tables in the order in which they are specified in the statement that is being explained.

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.

What effect will the new configuration have on existing account?

A. They are not affected by this configuration change.

B. They all connect via the secure sha256_password algorithm without any configuration change.

C. They will have their passwords updated on start-up to sha256_password format.

D. They will have to change their password the next time they login to the server.

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.)

A. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

B. Add a functional index for YEAR(Birthday).

C. Execute ANALYZE TABLE to update the index statistics.

D. Add a generated column calculating YEAR(Birthday) and index that column.

E. Add FORCE INDEX (Birthday) to the query.