美文网首页
oldguo-MySQL 8.0 OCP 原题解析-Q24

oldguo-MySQL 8.0 OCP 原题解析-Q24

作者: MySQL_oldguo | 来源:发表于2021-07-08 16:21 被阅读0次

Question 24:

Examine this SQL statement:

mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

Which two are true?

A) ADMIN OPTION causes the role to be activated by default.

B) Mark can revoke the r_read@localhost role from another role.

C) Mark can grant the privileges assigned to the r_read@localhost role to another user.

D) Mark can grant the r_read@localhost role to another user.

E) ADMIN OPTION allows Mark to drop the role.

F) Mark must connect from localhost to activate the r_read@localhost role.

相关文章

网友评论

      本文标题:oldguo-MySQL 8.0 OCP 原题解析-Q24

      本文链接:https://www.haomeiwen.com/subject/cuqbjltx.html