Exactprep 1z0-888 Questions

MySQL 5.7 Database Administrator Questions and Answers

Question 13

Which statement is correct about how InnoDB storage engine uses disk space?

It stores data in .MYD files and its index and undo information in the common tablespace.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

It stores its data, index and undo information in .MYD and .MYI files.

It stores data, index and undo information in tablespace file(s).

Question 14

You are investigating the performance of the server and see this information:

events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
The Table_open_cache_overflows status variable is 0.

Which action should be taken to remove the performance bottleneck described here?

Increase the value of table_open_cache_instances.

Decrease the value of table_definition_cache.

Decrease the value of table_open_cache.

Increase the value of table_definition_cache.

Increase the value of table_open_cache.

Decrease the value of table_open_cache instances.

Question 15

Host slave1 has ip address 192.0.2.10.

Host slave2 has ip address 203.0.113.50

Examine these commands:

Why did this error occur?

The host on the command line is not defined in the login path.

The mysqld instance has not been restarted after creating the login path.

There is no password defined in the login path.

The DNS is not configured correctly for slave1 host.

The .mylogin.cnf file is not readable.

Question 16

You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave.

Which procedure would you execute from a MySQL prompt?