Free 1z0-888 – MySQL 5.7 Database Administrator Practice Test Question

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.
  
  

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;
  
  

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;
  
  

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.
  
  

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
  
  

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.
  
  

Select an option, then click Submit answer.

• ○

  include-log-file

• ○

  master-binlog

• ○

  include-master-info

• ○

  master-data
  
  

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.
  
  

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
  
  

Select an option, then click Submit answer.

• ○

  It allows a client to process scripts.

• ○

  It allows the use of stored routines.

• ○

  It allows a client to see another user’s queries with the SHOW PROCESSLIST command.

• ○

  It allows a client to control running processes on a server.