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?

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

Comment: *

Name: *

Email: *

Verification: *

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

• A.binlog_cache_size=1024is too small and transactions are lost.
• B.binlog_format=STATEMENTand a non-deterministic query was executed.
• C.enforce_gtid_consistency=ONand consistency is broken between the master and the slave.
• D.The sync_relay_log=1000setting on the slave is too small.
• E.sync_binlog=0and the master server crashed.

Comment: *

Name: *

Email: *

Verification: *

On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

• A.If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
• B.Use the LIMIT clause in conjunction with the ORDER BY clause.
• C.Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.
• D.Use the LIMIT clause to limit the deletion to 100,000 rows.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Add FORCE INDEX (Birthday)to the query.
• B.Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
• C.Add a generated column calculating YEAR(Birthday)and index that column.
• D.Add a functional index for YEAR(Birthday).
• E.Execute ANALYZE TABLEto update the index statistics.

Comment: *

Name: *

Email: *

Verification: *

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

• A.monitoring cumulative Innodb_page_size increase
• B.monitoring the performance_schema_hosts_size variable
• C.monitoring the Innodb_rows_inserted status variable
• D.monitoring the information_schemA.TABLES table
• E.monitoring datadir size in the operating system
• F.monitoring the innodb_redo_log_size variable

Comment: *

Name: *

Email: *

Verification: *