Which of these grant table scope columns is case insensitive?
A. Host
B. User
C. Password
D. Db
Answer: Option C
Solution(By Examveda Team)
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.Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion