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?

1. A. They are not affected by this configuration change.
2. B. They all connect via the secure sha256_password algorithm without any configuration change.
3. C. They will have their passwords updated on start-up to sha256_password format.
4. D. They will have to change their password the next time they login to the serve

Correct Answer: A

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?

1. A. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
2. B. Add a functional index for YEAR(Birthday).
3. C. Execute ANALYZE TABLE to update the index statistics.
4. D. Add a generated column calculating YEAR(Birthday) and index that column.
5. E. Add FORCE INDEX (Birthday) to the quer

Correct Answer: AE

Which two methods accurately monitor the size of your total database size over time?

1. A. monitoring the Innodb_rows_inserted status variable
2. B. monitoring the innodb_redo_log_size variable
3. C. monitoring the information_schemA.TABLES table
4. D. monitoring datadir size in the operating system
5. E. monitoring cumulative Innodb_page_size increase
6. F. monitoring the performance_schema_hosts_size variable

Correct Answer: CF

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

1. A. the mysql_upgrade script
2. B. the mysql client with the --ignore-password-hashing option
3. C. the mysql_secure_installation script to update server security settings
4. D. the mysql client with the --enable-cleartext-plugin option
5. E. the install plugin command for the mysql_cleartext_password plugin

Correct Answer: C

You created a backup of the world database with this command: shell> mysqldump --opt world > dump.sql Which two will import the data from dump.sql?

1. A. shell> mysqladmin recover test dump.sql
2. B. shell> mysql test < dump.sql
3. C. shell> mysqlimport test dump.sql
4. D. mysql> USE test; mysql> LOAD DATA INFILE ‘dump.sql’;
5. E. mysql>USE test; mysql>SOURCE dump.sql;

Correct Answer: CD