Which of the following pairs of SQL commands do not belong to the same category?

Correct option is C

The pair Select and Revoke do not belong to the same category in SQL. Select is a Data Query Language (DQL) command used for retrieving data from a database, while Revoke is a Data Control Language (DCL) command used for removing user permissions. These commands serve entirely different purposes and belong to separate SQL command categories.
Important Key Points:
1. Select Command: Belongs to the DQL category, used for querying data from tables.
2. Revoke Command: Belongs to the DCL category, used to manage user privileges by revoking permissions.
3. Categorical Difference: Select focuses on data retrieval, while Revoke manages access control.
Knowledge Booster:
· Delete, Insert : Both are part of Data Manipulation Language (DML), used to modify data in tables.
· Select, Update: Select is DQL, while Update is DML; however, both involve data manipulation.
· Grant, Revoke: Both belong to DCL, used for managing user permissions.