MySQL8.0认证 1Z0-908考题汇总.pdf

153

182页

7次

2025-05-08

5墨值下载

mysql 8.0

1、

Choose the best answer.

Examine these statements and output:

mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ;

mysql> SELECT USER(), CURRENT_USER(), @@proxy_user;

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 logged in with --user=accounting as an option.

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

Answer：E

分析：proxy 用户创建构成

-- create proxy account

CREATE USER 'employee_proxy'@'%' identified by '123456';

-- create proxied account and grant its privileges;

CREATE USER 'employee'@'localhost' identified by '123456';

GRANT ALL ON *.* TO 'employee'@'localhost';

-- grant to proxy account the

GRANT PROXY ON 'employee'@'localhost' TO 'employee_proxy'@'%';

https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html

CURRENT_USER()的权限是真正当前作用的用户权限。

2、

Choose two.

Which two actions can obtain information about deadlocks?

A) Run the SHOW ENGINE INNODB MUTEX command from the mysql client.

B) Enable the innodb_status_output_locks global parameter.

C) Enable the innodb_print_all_deadlocks global parameter.

D) Run the SHOW ENGINE INNODB STATUS command from the mysql client.

E) Use the sys.innodb_lock_waits view.

Answer：C ，D

innodb_print_all_deadlocks

When this option is enabled, information about all deadlocks in InnoDB user transactions is

recorded in the mysqlderror log. Otherwise, you see information about only the last deadlock,

using the SHOW ENGINE INNODB STATUScommand.

of 182

5墨值下载

关注