Home » MCQs » MariaDB MCQs

Which is the correct MariaDB query for removing a default role from the current user?

49. Which is the correct MariaDB query for removing a default role from the current user?

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

Answer: A) SET DEFAULT ROLE NONE;

Explanation:

The correct MariaDB query for removing a default role from the current user is:

Syntax:

SET DEFAULT ROLE NONE;