Examine the mydata table and SELECT statements:

You issue:

mysql> begin;

mysql> update mydata set a=0 where b=3;

How many rows are now protected by locks with the default InnoDB configuration?

A. one

B. one row and a next-key lock for supremum

C. one row and a gap-lock

D. five

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

A. innodb_buffer_pool_size

B. max_connections

C. join_buffer_size

D. character_set_system

E. innodb_log_file_size

F. max_user_connections

G. port

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

A. the PERFORMANCE_SCHEMA tables

B. the SHOW PROCESSLIST command

C. the INNODB Lock Monitor details

D. the SHOW STATUS command

E. the INFORMATION_SCHEMA tables

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)

A. a backup created with mysqldump --all-databases

B. a backup created using FLUSH TABLES ... FOR EXPORT

C. an up-to-date replication slave

D. a file system-level snapshot

E. a file system copy created while MySQL was shut down.

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

B. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

C. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

D. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.