Download Oracle.1z0-320.PracticeTest.2018-04-04.46q.tqb

Vendor:	Oracle
Exam Code:	1z0-320
Exam Name:	MySQL Cloud Service 2018 Implementation Essential
Date:	Apr 04, 2018
File Size:	310 KB
Downloads:	1

Download Exam

Demo Questions

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?

CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
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’;
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’;
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 *.* 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’;
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’;

Correct answer: A

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?