mysql8.0英文OCP考试第31-40题

Q31.What is the correct syntax for using transparent data encryption with an existing InnoDB table?

A)ALTER TABLE t1 ENCRYPTION='Y';

B)ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

C)ALTER TABLE t1 SET TDE = 'ON';

D)ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

Answer:A

Q32.Examine these statements and output:

Mysql>GRANT PROXY ON accounting@locahost TO ‘’@’%’;

Mysql>SELECT USER(),CURRENT_USER(),@@PROXY_USER;

+-------------------+---------------------+----------------+

|USER()           |CURRENT_USER()   |@@proxy_user|

+-------------------+---------------------+----------------+

|jsmith@loaclhost | accounting@localhost |’’@’%  |

+-------------------+---------------------+----------------+

Which statement is true?

A)The user failed to define a username and the connecting username defaulted to ' '@'%'.

B)The user is authorized as the rsmith@localhost user.

C)The user is authenticated as the anonymous proxy user ' '@'%'.

D)The user is authorized as the accounting@localhost user.