ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which grant table scope columns are case insensitive?

Answer & Solution
Correct Answer: Option B
In MySQL, certain grant table scope columns are case insensitive, meaning they do not distinguish between uppercase and lowercase characters.

The correct option is Option B: User.

Explanation:
Host: The host column in the grant tables is case sensitive, as it distinguishes between different hosts based on their exact names.
User: The user column in the grant tables is case insensitive, meaning it treats usernames the same regardless of whether they are in uppercase or lowercase.
Password: The password column stores encrypted passwords and is not related to case sensitivity.
Db: The db column represents the database name and is case sensitive, as it distinguishes between different databases based on their exact names.

Therefore, Option B: User is the correct answer as the grant table scope column that is case insensitive.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.