Which grant table scope columns are case insensitive?
A. Host
B. User
C. Password
D. Db
Answer: Option B
Solution(By Examveda Team)
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.
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