PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements properly removes any alteration privileges from Group_2?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
REVOKE INSERT,
UPDATE, DELETE ON
Employees FROM Group_2;

B.
REVOKE
UPDATE FOR
Employees
FROM Group_2;

C.
REVOKE INSERT,
UPDATE, DELETE ON
Employees FOR Group_2;

D.
REVOKE
UPDATE, DELETE
FOR Employees
FROM Group_2;

One Comment on “Which of the following SQL statements properly removes any alteration privileges from Group_2?


Leave a Reply