Which three are characteristics of a newly created role? (Choose three.)
Which three are characteristics of a newly created role? (Choose three.)
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.
The three correct statements are A, C, and E. 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.
The three correct statements are A, C, and E. 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.
Agree, A,C,E
hi please can anyone send me the dumps
ACE It is created as a lock account
Correct answer is A,C,E https://dev.mysql.com/doc/refman/8.0/en/roles.html