mysql8.0英文OCP考试第141-150题

Q141.Which two are features of MySQL Enterprise Firewall? (Choose two.)

A)recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

B)blocking of potential threats by configuring pre-approved whitelists

C)modifying SQL statement dynamically with substitutions

D)automatic locking of user accounts who break your firewall

E)provides stateless firewall access to TCP/3306

Answer:AB

Q142.Examine the modified output:

mysql> SHOW SLAVE STATUSIG

*********************************1. row****************************

Slave_ I0_ Running: Yes

Slave_ SQL_ Running: Yes

seconds_ Behind_ Master: 1612

Seconds_ Behind_ Master value is steadily growing.

What are two possible causes? (Choose two.)

A)The master is most probably too busy to transmit data and the slave needs to wait for more data.

B)One or more large tables do not have primary keys.

C)This value shows only I/0 latency and is not indicative of the size of the transaction queue.

D)The master is producing a large volume of events i