Q41
Which grant table scope columns are case insensitive?
A.
Host
B.
User
AnswerC.
Password
D.
Db
Answer: Option B
Solution
Answer: Option B
Solution:
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.