Exam 1z0-908 topic 1 question 57 discussion

Tested it. A and F are correct options.

A. It fails if any of the roles is specified in the mandatory_roles variable. Roles named in the mandatory_roles system variable value cannot be dropped. F. It fails if at least one of the roles does not exist. By default, an error occurs if you try to drop a role that does not exist. However, if the IF EXISTS clause is given, the statement produces a warning for each named role that does not exist, rather than an error.

correction, A and F. You don't need to reload connection if role changes.

I tested it, you can drop a role if users have that role. You need grant and revoke privs to manipulate roles. I also tested deleting a role that didn't exist, it errored. C and F.

A and F

B. This is true. Before dropping a role, you need to make sure that the role is not assigned to any user or any other role. Otherwise, the DROP ROLE statement will fail with an error message. C. This is also true. Existing connections that are currently using the privileges of the roles being dropped can continue to do so until they disconnect and reconnect.