Vidyalelo
MySQL · Q210

MySQL

Programming · MySQL · question 210

Q210

For REVOKE statements, the server automatically rereads the grant tables.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
This question asks about the behavior of the REVOKE statement in MySQL.
The REVOKE statement is used to take away privileges that were previously granted to a user or role.
The question is asking if, after a REVOKE statement is executed, MySQL automatically updates its internal tables (called grant tables) that store information about user privileges.
The answer is True.
When you use REVOKE to remove permissions, MySQL immediately updates its grant tables to reflect the changes. This ensures that the database enforces the new permissions accurately.
So, the correct answer is Option A: True.