Percy is promoted and is no longer responsible for making updates to several database tables. Which command should Percy's database administrator use to prevent Percy from making future updates?
A) DROP
B) REMOVE
C) REVOKE
D) CANCEL

Question

Quizplus · Accepted Answer

The REVOKE command is used in SQL to remove or restrict the ability of a user to perform certain actions on database objects, such as tables. In this scenario, to prevent Percy from making future updates to the database tables, the database administrator should use the REVOKE command to remove Percy's update privileges on those tables.

Percy Is Promoted and Is No Longer Responsible for Making