Home » MCQs » MariaDB MCQs

Which is the correct MariaDB query for removing a default role for another user ('alex')?

50. Which is the correct MariaDB query for removing a default role for another user ('alex')?

1. SET DEFAULT ROLE NONE FOR alex;
2. SET DEFAULT ROLE NULL FOR alex;
3. SET DEFAULT ROLE EMPTY FOR alex;
4. SET DEFAULT ROLE REMOVE FOR alex;

Answer: A) SET DEFAULT ROLE NONE FOR alex;

Explanation:

The correct MariaDB query for removing a default role for another user ('alex') is:

Syntax:

SET DEFAULT ROLE NONE FOR alex;