Question 31
Which two methods will provide the total number of partitions on a table? (Choose two.)
Question 32
The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?
Question 33
Which two methods will provide the total number of partitions on a table? (Choose two.)
Question 34
A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?
Question 35
The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

Which two facts are true about these tables? (Choose two.)