mysql8.0英文OCP考试第71-80题

Q71.MySQL is installed on a Linux server with this configuration:

[mysqld]

user=mysql

datadir=/data/mysql

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

A)Set validate-user-plugins=caching_sha2_password in the configuration file.

B)Add default_authentication_plugin=sha256_password in the configuration file.

C)Add default_authentication_plugin=mysql_native_password in the configuration file.

D)Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

Answer:B

Q72.Examine these statements, which execute successfully:

TRUNCATE test;

BEGIN;

INSERT INTO test(id, name) VALUES(1, "HELLO");

ROLLBACK;

SELECT id FROM test;

Which three storage engines would return a nonempty recordset for the test table when executing the statements?

A)BLACKHOLE

B)MEMORY

C)MyISAM     

D)InnoDB