Free 1z0-908 – MySQL 8.0 Database Administrator Practice Test Question

Select an option, then click Submit answer.

• ○

  Increase the number of buffer pool instances to 16.

• ○

  Increase the number of buffer pool instances to 32.

• ○

  Decrease the number of buffer pool instances to 1.

• ○

  Increase the number of buffer pool instances to 12.

• ○

  Decrease the number of buffer pool instances to 4.

Select an option, then click Submit answer.

• ○

  It monitors and schedules the rotation/deletion of the binary logs.

• ○

  It reads the relay log and executes the events contained in them.

• ○

  It acquires a lock on the binary log for reading each event to be sent to the slave.

• ○

  It connects to the master and asks it to send updates recorded in its binary logs.
  
  

Select an option, then click Submit answer.

• ○

  20

• ○

  24
  

• ○

  21

• ○

  25

• ○

  22

• ○

  6