Online Access Free 1z1-320 Practice Test

Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1.
BEGIN;
CREATE TABLE t1 (c1 INT);
CREATE TABLE t2 (c1 INT);
ROLLBACK;
What is the result after issuing the ROLLBACK command?

• A.Only the t1 table is created.
• B.Only the t2 table is created.
• C.Both the tables, t1 and t2, are created.
• D.Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

After the installation of the MySQL Server, you cannot find MySQL Utilities.
How would you correct the problem?

• A.MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.
• B.MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.
• C.MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.
• D.MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.
• E.MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.

Identify three levels in which MySQL Enterprise Monitor provides access control.

• A.Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
• B.Asset visibility: the rights to access data collected from hosts or MySQL instances
• C.Specific data access: the rights to view specific types of potentially sensitive data
• D.MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
• E.MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

The following backup command is executed:
mysqlbackup --defaults-file=config/mysqlbackup.cnf --compress --port=3306 --host=127.0.0.1
--user=mysqlbackup --password --suspend-at-end backup
*** log started **
....
160308 14:43:00 mysqlbackup: INFO: Copying /home/mysql/data/07/test/xmltable.ibd (Barracuda file format).
160308 14:43:00 mysqlbackup: INFO: Completing the copy of innodb files.
160308 14:43:00 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
160308 14:43:00 mysqlbackup: INFO: Starting to lock all the tables...
160308 14:43:00 mysqlbackup: INFO: All tables are locked and flushed to disk mysqlbackup: INFO:
--suspend-at-end option is specified.
160308 14:43:00 mysqlbackup: INFO: Suspending the backup procedure to wait until the marker file
'/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' is deleted.
....
*** log ended **
Which option allows mysqlbackup to continue backing up the rest of the data?

• A.Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified "processed" .mysqlbackup will continue
• B.Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue
• C.Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES;
• D.Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup;
• E.An external program or manual work is to be executed to complete the backup and the marker file
  "/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally.
  After the file is removed, mysqlbackup will continue

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.
Which syntax accomplishes this?

• A.CREATE USER 'mysqlbackup'@localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON
  *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON
  mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost';GRANT SUPER ON *.* TO 'mysqlbackup'@' localhost;GRANT PROCESS ON *.* 'mysqlbackup'@'localhost';
• B.CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost';
• C.CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* TO ''mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@localhost';
• D.CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* to 'mysqlbackup'@localhost';GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ONmysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* to 'mysqlbackup'@'localhost';GRANT SUPER ON *.* TO
  'mysqlbackup'@'localhost';GRANT PROCESS ON *.* TO 'mysqlbackup'@'localhost';GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO 'mysqlbackup'@'localhost';
• E.CREATE USER 'mysqlbackup'@localhost'IDENTIFIED BY 'new-password';