Question: 1
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?
Question: 2
Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer?
Question: 3
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?
Question: 4
Which two statements are true regarding the creating of new MySQL physical and logical backups?
Question: 5
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?