MySQL 8.0 Database Administrator — Question 9

Which three are characteristics of a newly created role? (Choose three.)

Answer options

• A. It can be dropped using the DROP ROLE statement.
• B. It is stored in the mysql.role table.
• C. It is created as a locked account.
• D. It can be renamed using the RENAME ROLE statement.
• E. It can be granted to user accounts.
• F. It can be protected with a password.

Correct answer: A, C, E

Explanation

The correct answers are A, C, and E because a newly created role can indeed be dropped with the DROP ROLE statement, initialized as a locked account, and granted to user accounts. Options B and D are incorrect because the role is not just stored in the mysql.role table and cannot be renamed using the RENAME ROLE statement.