← Back to exam page

1z0-888 – MySQL 5.7 Database Administrator

Loading demo links...

Showing 7–9 of 10 questions

Question 7

You need to dump the data from the master server and import it into a new slave server.

Which mysqldump option can be used when dumping data from the master server in order to include the master server’s binary log information?

Select an option, then click Submit answer.

  • ○

    include-log-file
  • ○

    master-binlog
  • ○

    include-master-info
  • ○

    master-data
Question 8

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.

Which statement describes the activation of that access for the user?

Select an option, then click Submit answer.

  • ○

    The access does not take effect until the user logs out and back in.
  • ○

    The access does not take effect until the next time the server is started.
  • ○

    The access is available immediately.
  • ○

    The access does not take effect until you issue the FLUSH PRIVILEGES statement.
Question 9

The MySQL instance is a default RPM installation on a Linux server.

Where are the errors written?

Select an option, then click Submit answer.

  • ○

    in the /var/lib/mysql/hostname.log file
  • ○

    no logging enabled by default
  • ○

    in the /var/log/mysqld.err file
  • ○

    in the syslog daemon on the server