CIW Exam 1D0-541 Topic 6 Question 38 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 38
Topic #: 6

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?

AREVOKE
INSERT, UPDATE, DELETE
ON Employees
FROM Group_2;

BREVOKE
UPDATE
FOR Employees
FROM Group_2;

CREVOKE
INSERT, UPDATE, DELETE
ON Employees
TO Group_2;

DREVOKE
UPDATE, DELETE
FOR Employees
FROM Group_2;

Show Suggested Answer

Suggested Answer: A

by Dorothy at May 07, 2022, 08:43 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!