← Back to exam page

1z0-888 – MySQL 5.7 Database Administrator

Loading demo links...

Showing 1–3 of 10 questions

Question 1

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:

USE prices;

UPDATE sales.january SET amount=amount+1000;

An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.

Which statement is true? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
  • ○

    The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
  • ○

    The statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.
  • ○

    Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
  • ○

    Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
Question 2

You want to immediately stop access to a database server for remote user ‘mike’@’client.example.com’. This user is currently not connected to the server.

Which two actions can you take to stop any access from the user? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Use ALTER USER ‘mike’@’client.example.com’ PASSWORD EXPIRE;
  • ○

    Use REVOKE ALL PRIVILEGES FROM ‘mike’@’client.example.com’;
  • ○

    Execute the mysql_secure_installation command.
  • ○

    Use DROP USER ‘mike’@’client.example.com’;
  • ○

    Use GRANT USAGE ON *.* TO ‘mike’@’client.example.com’ MAX_USER_CONNECTIONS=0;
  • ○

    Use ALTER USER ‘mike’@’client.example.com’ ACCOUNT LOCK;
Question 3

You created a backup of the world database with this command: shell> mysqldump --opt world > dump.sql

Which two will import the data from dump.sql? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    shell> mysqladmin recover test dump.sql
  • ○

    shell> mysql test < dump.sql
  • ○

    shell> mysqlimport test dump.sql
  • ○

    mysql> USE test; mysql> LOAD DATA INFILE ‘dump.sql’;
  • ○

    mysql>USE test; mysql>SOURCE dump.sql;