Which three are characteristics of a newly created role? (Choose three.)
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.
The Answer Is:
A, C, E
This question includes an explanation.
Explanation:
A newly created role in MySQL 8.0 can be dropped using the DROP ROLE statement, is created as a locked account, and can be granted to user accounts. It is not stored in a mysql.role table, but rather in the mysql.user table. It cannot be protected with a password, as it has no password when created.
1z0-908 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"