mysql8.0英文OCP考试第111-120题

Q111.You recently upgraded your MySQL installation to MySQL 8.0

Examine this client error:

ERROR 2059 (HY000): Authentication plugin 'caching sha2_ password" cannot be

loaded:  /usr/ local/mysql/1ib/plugin/caching sha2_ password.so: cannot open shared

object file: NO such file or directory

Which option will allow this client to connect to MySQL Server ?

A)[mysqld]

Default_authentication_plugin=caching sha2_password

B)AITER USER user

IDENTIFIED WITH mysql_ native_ password BY 'password' ;

C)AITER USER user

IDENTIFIED WITH caching_ sha2_password BY 'password' ;

D)[mysqld]

Default_authentication_plugin=sha256_password;

E)ALTER USER user

IDENTIFIED WITH sha256_ password BY 'password;

F)[mysqld]

Default_authentication_plugin=mysql_native_password

Answer：B

Q112.Which three methods are part of a 'scale up' approach to capacity planning?

A)adding additional MySQL servers to the existing host

B)adding more CPU power

C)adding a replication slave

D)adding more RAM

E)adding more storage to your disk array

F)sharding the server into a parallel server farm

G)adding a new