← Back to exam page

1z0-888 – MySQL 5.7 Database Administrator

Loading demo links...

Showing 4–6 of 10 questions

Question 4

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
  • ○

    A .mylogin.cnf file can store at most one login path.
  • ○

    It provides a FIPS-compliant keyring for storing MySQL login details.
  • ○

    A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
  • ○

    It is an alternative to storing the MySQL login details in a my.cnf file.
  • ○

    It provides means to help avoid accidentally exposing the MySQL login details.
Question 5

Which two capabilities are granted with the SUPER privilege? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    allowing change of the server runtime configuration
  • ○

    allowing a client to shut down the server
  • ○

    allowing client accounts to take over the account of another user
  • ○

    allowing a client to kill other client connections
Question 6

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?

Select an option, then click Submit answer.

  • ○

    MySQL starts and Binary Logging is enabled.
  • ○

    MySQL fails to start due to the conflicting options in the configuration files.
  • ○

    MySQL fails to start due to conflicting options on the command line.
  • ○

    MySQL starts but Binary Logging is disabled.