Online Access Free 1z0-320 Exam Questions

You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user 'employee1' from MySQL Workbench by first selecting Server> Users and Privileges> employee1?

• A.Set Max. Queries to 14 for 'employee1'.
• B.Set Max Updates to 4 for 'employee1'.
• C.Set Concurrent Connections to 14 for 'employee1'.
• D.Set Max. Connections to 14 for 'employee1'.
• E.Set Max. Queries to 10 for 'employee1'.

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 not created because there is an explicit ROLLBACK.
• D.Both the tables, t1 and t2, are created.

An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysqldump and mysql client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What are two benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

• A.mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
• B.MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.
• C.MySQL Enterprise Backup does not back up system data so that it is much faster.
• D.mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
• E.mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

• A.CREATE TABLE City_part LIKE City;
• B.INSERT INTO City_part SELECT * FROM City;
• C.CREATE TABLE City_part AS SELECT * FROM City;
• D.CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;

You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature?

• A.Use UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name='statements_digest';
• B.Use UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name =
  'statements_digest';
• C.MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL
• D.For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server.