Oracle 1z0-908 Question Answer
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
It fails if any of the roles is specified in the mandatory_roles variable.
You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
Existing connections can continue to use the roles’ privileges until they reconnect.
You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
It fails if at least one of the roles does not exist.
TESTED 12 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved