mysql8.0英文OCP考试第51-60题

Q51.Examine this parameter setting:

audit_log=FORCE_LOG_OERMAENT

What effect does this have on auditing?

A)It will force the load of the audit plugin even in case of errors at server start.

B)It causes the audit log to be created if it does not exist.

C)It prevents the audit plugin from being removed from the running server.

D)It prevents the audit log from being removed or rotated.

Answer:C

Q52.You recently upgraded your MYSQL installation to MYSQL8.0 Examine this client error:

Error 2059 (HY000):authentication plugin ‘caching_sha2_password’ cannot be

Loaded: /usr/local/mysql/libplugin/caching_sha2_password.so: cannot open shared object file: No such or directory

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

A)[mysqld] default_authentication_plugin=sha256_password

B)[mysqld] default_authentication_plugin=caching_sha2_password

C)ALTER USER user IDENTIFIED WITH mysql_native_password BY ‘password’;

D)ALTER USER user IDENTIFIED WITH caching_sha2_password

E)ALTER USER user IDENTIFIED WITH sha256_password

F)[mysqld] default_authentication_plugin=mysql_native_password

Answer:C

Q53.You made some table definition changes to a schema in your MySQL Server.

Which two statements reflect how MySQL Server handles the table definition changes?

A)MySQL keeps InnoDB metadata changes in .sdi files in datadir.

B)MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

C)MySQL writes SDI to the binary log for distributed backups.

D)MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

E)The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

说明：InnoDB