You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.

Which statement describes the activation of that access for the user?

A. The access does not take effect until the user logs out and back in.

B. The access does not take effect until the next time the server is started.

C. The access is available immediately.

D. The access does not take effect until you issue the FLUSH PRIVILEGES statement.

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

A. to allow the remaining events to be processed on the slave while not receiving new events from the master

B. to allow a backup to be created under reduced load

C. to allow for point-in-time recovery on the slave

D. to prevent schema changes from propagating to the slave before they are validated

E. to prevent any transaction experiencing a deadlock

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

A. Run the create_system_tables.sql file

B. Run the mysql_unpack.sql file

C. Invoke mysqld with the --initialize option.

D. Invoke mysql with the --initialize option.

You back up by using mysqldump.

Which configuration is required on the MySQL Server to allow point-in-time recovery?

A. binlog_format=STATEMENT

B. log-bin

C. apply-log

D. bonlog_format=ROW

E. gtid_enable

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)

A. a backup created with mysqldump --all-databases

B. a backup created using FLUSH TABLES ... FOR EXPORT

C. an up-to-date replication slave

D. a file system-level snapshot

E. a file system copy created while MySQL was shut down.

Consider the CHECK TABLE command.

In which two situations should this command be used? (Choose two.)

A. to find out why a query takes a long time to execute on a given table

B. to make sure a table has no structural problems

C. to improve performance by updating index distributing statistics on InnoDB tables

D. to repair table structure problem

E. to make sure that no table indexes are corrupted

Which statement is true about tablespaces?

A. All tablespace files must be in the directory specified by the –-datadir option.

B. General tablespaces can be configured to span multiple files.

C. All tables must be in either the system tablespace or a general tablespace.

D. The system tablespace can be configured to span multiple files.

You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.

Which three statements are true? (Choose three.)

A. The performance impact is less than SHOW FULL PROCESSLIST.

B. The PROCESS privilege is required.

C. The events_statements_current consumer must be enabled.

D. A connection must be instrumented to be included in the list of processes.

E. The sys.session view provides the process list with additional information.

F. The threads table contains all the required columns.

You want to create the first configuration file for a new installation of MySQL.

1.

You will start mysqld manually (not automate it to start when the host machine starts or execute as a service).

2.

You will stop mysqld using mysqladmin.

3.

You will interact with mysqld by using only the command-line client mysql.

Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

A. [mysql] and [mysqld] and [mysqladmin]

B. [mysql] and [mysqladmin]

C. [mysql]

D. [mysqld]

E. [mysqld] and [mysqladmin]

F. [mysqladmin]

G. [mysql] and [mysqld]

A general purpose MySQL instance is configured with the following options:

--slow-query-log --long-query-time=.0001 --log-queries-not-using-indexes --log-slow-admin-queries --general-log --log-bin --binlog-format=STATEMENT --innodb-flush-log-at-trx-commit=1

Which three statements are true for most workloads? (Choose three.)

A. The Slow Query Log records more data than the General Query Log.

B. The General Query Log records more data than the Slow Query Log.

C. The Slow Query Log records more data than the Binary Log.

D. The Binary Log records more data than the General Query Log.

E. The Binary Log records more data than the Slow Query Log.

F. The General Query Log records more data than the Binary Log.