Oracle Exam 1Z0-908 Topic 5 Question 14 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 14
Topic #: 5

[All 1Z0-908 Questions]

Examine this statement:

mysql> DROP ROLE r_role1, r_role2;

Which two are true? (Choose two.)

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

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

CExisting connections can continue to use the roles' privileges until they reconnect.

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

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

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

Show Suggested Answer

Suggested Answer: C, E

by Jettie at May 07, 2022, 12:21 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!