1Z0-888 Online Practice Questions and Answers

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a `SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in

this case. One or more statements are required before you can issue a START SLAVE command to

resolve the duplicate key error.

Which statement should be used?

A. SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";

B. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";

C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

D. SET GLOBAL enforce_gtid_consistency=ON

E. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";

SQL injection is a common security threat.

Which two methods would help protect against this risk?

A. using stored procedures to validate values that are input

B. using SQL variables to secure input values

C. using prepared statements to handle unsecured values

D. installing the SQL Protection plugin to catch such attempts

E. starting the server with the ?injection-protection command-line option.

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.

The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

A. Key Buffer Size

B. InnoDB Redo Log Size

C. Binary Log Size

D. Buffer Pool Size

E. Sort Buffer size

F. Query Cache Size

The Performance Schema includes these tables related to status variables: Which two facts are true about these tables? (Choose two.)

A. The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

B. All these tables have the same number of rows.

C. The global_status table is equivalent to the SHOW GLOBAL STATUS statement.

D. The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.

E. The session_status table is equivalent to status_by_thread for the current thread.

You have created a backup of the `sales' database with the command:

Which two procedures can be used to restore the `orders' table from the backup?

A. Option A

B. Option B

C. Option C

D. Option D

You want to dump only data from the userdata table.

Which mysqldump command argument is required to accomplish this?

A. - -no-create-info to skip writing CREATE TABLE statements

B. - -single-transaction as this obtains a consistent view of data only

C. - -data-only as this specifies that only data is to be dumped

D. - -table=userdata in order to dump only the data from the userdata table

What does the Performance Schema provide?

A. insight into the internal working of MySQL

B. recommendations for schema changes

C. a text-based version of MySQL Enterprise Monitor

D. auto-tuning based on settings and ongoing workload

Which statement best describes a "warm" backup?

A. It is similar to a "cold" backup, but differs in that it permits write operations.

B. It backs up the binary log, which contains the most recent "warm" changes.

C. It is similar to a "hot" backup, but differs in that it does not permit write operations.

D. It only backs up "warm" data, that is, data that has been recently modified.