mysql8.0英文OCP考试第21-30题

Q21.You encountered an insufficient privilege error in the middle of a long transaction.

The database administrator is informed and immediately grants the required privilege:

GRANT UPDATE ON world.city TO 'user1';

How can you proceed with your transaction with the least interruption?

A)Roll back the transaction and start the transaction again in the same session.

B)Change the default database and re-execute the failed statement in your transaction.

C)Re-execute the failed statement in your transaction.

D)Close the connection, reconnect, and start the transaction again.

Answer:C

Q22.An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication?

A)On the slave, alter the MySQL master connection setting with:

CHANGE MASTER TO MASTER_AUTO_POSITION = 1; 

B)Execute this on the slave to enable GTID:

RESET SLAVE; START SLAVE GTID_NEXT = AUTOMATIC;

C)Enable GTID by executing this on the master and the slave:

SET GLOBAL GTID_ENABLED = on;

D)Restart MySQL (master and slave) with these options enabled:

--gtid_mode=ON

--log-bin

--log-slave-updates

--enforce-gtid-consistency

E)On the slave, alter the MySQL master connection setting with:

ALTER