Discuss CIW 1D0-541 Exam Topic 6 Question 38

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;

Suggested Answer: A

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Winfred 11 months ago

Wait, can you really revoke multiple privileges like that?

Gianna 11 months ago

B seems off, it only revokes UPDATE, not all alterations.

Gary 11 months ago

I thought FOR was the right keyword? Confused.

Brianne 11 months ago

Totally agree, A makes the most sense here.

Roy 11 months ago

A is the correct syntax for revoking privileges.

Carlee 12 months ago

I’m leaning towards option A because it seems to cover all the necessary actions, but I’m not completely confident about the exact syntax.

Solange 12 months ago

I feel like "FROM" is the right choice, but I’m confused about whether we should use "TO" or "FROM" in the context of revoking privileges.

Shanice 1 year ago

I think "REVOKE ON" is definitely the correct syntax, but I can't recall if we need to specify all the actions like INSERT, UPDATE, and DELETE together.

Whitley 1 year ago

I remember we practiced a similar question about revoking privileges, but I’m not sure if "FOR" is the right keyword here.

Louis 1 year ago

This seems like a straightforward compliance question. I'll focus on the key responsibilities of the compensation department and look for the answer that best aligns with that.

Celestina 1 year ago

Groups in the IBM RPA web client - I've got this! They refer to the different user roles and permissions that can be set up, like super-admin, admin, and regular users. I'm pretty sure option A is the correct answer here.

Blondell 1 year ago

I want to say 1 is a relationship, but that feels off... I'm leaning towards option C, but it's tricky!

CIW 1D0-541 Exam - Topic 6 Question 38 Discussion