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

Which of these grant table scope columns is case insensitive?

Answer & Solution
Correct Answer: Option C
In MySQL, the "Password" column in the grant tables, such as "mysql.user" table, is case insensitive. This means that when you grant or revoke privileges, the password is matched without considering the case sensitivity. This is particularly important for security reasons, ensuring that users can authenticate regardless of the case of their password input. Hence, Option C is correct.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.