Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?
A) REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;
B) REVOKE UPDATE FOR Employees FROM Group_2;
C) Employees FOR Group_2;
D) UPDATE, DELETE FOR Employees

Question

Quizplus · Accepted Answer

The REVOKE statement is used to remove privileges from users. Option A correctly uses the REVOKE statement to remove INSERT, UPDATE, and DELETE privileges from Group_2 on the Employees table.

Your Database Administrator Has Disallowed a Group of Users from Making