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?
  • 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?
  • Question 35

    The Performance Schema includes these tables related to status variables:

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