1Z0-908 Exam Question 21

Examine these commands and output:

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?
  • 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.)
  • 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.)
  • 1Z0-908 Exam Question 25

    Which three are characteristics of a newly created role? (Choose three.)