首页 试题详情
多选题


Choose two.
Examine this statement:
Mysql> DROP ROLE r_role1, r_role2; Which two are true?

AYou must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

BYou must revoke all privileges from r_role1 and r_role2 before dropping the roles.

CIt fails if at least one of the roles does not exist.

DExisting connections can continue to use the roles‘ privileges until they reconnect.

EIt fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

FIt fails if any of the roles is specified in the mandatory_roles variable.

查看答案
正确答案：A （备注：此答案有误）

相似试题

  • 多选题

    Choose two.Examine this command and output:

    答案解析

  • 多选题

    Choose two.Examine this statement:Mysql> DROP ROLE r_role1, r_role2; Which two are true?

    答案解析

  • 多选题

    Choose two.Examine this command and output:Select * from table_lock_waits_summary_by_table where COUNT_STAR > 0 limit 1 GWhich two are true?

    答案解析

  • 多选题

    Choose two.Examine this statement, which executes successfully:CREATE USER mary@192.0.2.100 IDENTIFIED BY ‘P@SSw0rd‘ REQUIRE NONE PASSWORD EXPIRE;Which two are true?

    答案解析

  • 单选题

    Choose the best answer. Examine this output:

    答案解析

热门题库