1Z0-908 Exam Question 21
Examine these commands and output:

Which connection ID is holding the metadata lock?

Which connection ID is holding the metadata lock?
1Z0-908 Exam Question 22
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?
1Z0-908 Exam Question 23
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
1Z0-908 Exam Question 24
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
1Z0-908 Exam Question 25
Which three are characteristics of a newly created role? (Choose three.)
