MySQL 8.0 Database Administrator — Question 10

Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

Answer options

• A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
• B. ADMIN OPTION causes the role to be activated by default.
• C. Mark can grant the r_read@localhost role to another user.
• D. Mark can revoke the r_read@localhost role from another role.
• E. ADMIN OPTION allows Mark to drop the role.
• F. Mark must connect from localhost to activate the r_read@localhost role.

Correct answer: C, D

Explanation

The correct answers are C and D. C is correct because the ADMIN OPTION allows Mark to grant the role to other users. D is also correct because with the ADMIN OPTION, Mark can revoke the role from other users. Options A, B, E, and F are incorrect as they either misinterpret the ADMIN OPTION or do not reflect the privileges granted by the role.