Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb
Which two statements are true? (Choose two.)
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
Examine these statements and output:
Which statement is true?
Which three statements are true about MySQL replication? (Choose three.)