How does the InnoDB storage engine handle deadlocks when they are detected?

1. A. Both the affected transactions will be rolled back.
2. B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
3. C. One of the affected transactions will be rolled back, the other is allowed to proceed.
4. D. The transaction isolation level determines which transaction is rolled back.
5. E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled bac

Correct Answer: C

What is the best method for monitoring Group Replication conflict resolution?

1. A. the PERFORMANCE_SCHEMA tables
2. B. the SHOW PROCESSLIST command
3. C. the INNODB Lock Monitor details
4. D. the SHOW STATUS command
5. E. the INFORMATION_SCHEMA tables

Correct Answer: A

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

1. A. binlog_format=STATEMENT
2. B. log-bin
3. C. apply-log
4. D. bonlog_format=ROW
5. E. gtid_enable

Correct Answer: B

Which three options are most likely to be changed for production form their default values?

1. A. innodb_buffer_pool_size
2. B. max_connections
3. C. join_buffer_size
4. D. character_set_system
5. E. innodb_log_file_size
6. F. max_user_connections
7. G. port

Correct Answer: EFG

Exhibit:

What does the possible_keys column in this output denote?

1. A. if it is possible for you to include any indexes in your query
2. B. whether there are any indexes on the tables that you are querying
3. C. if there are any indexes that may be used to solve this query
4. D. whether there are any indexes in your query

Correct Answer: A