PostgreSQL Exam PGCES-02 Topic 2 Question 41 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 41
Topic #: 2

[All PGCES-02 Questions]

I would like to enable all users to SELECT the "item" table. Select the most appropriate SQL statement from below.

AGRANT public SELECT ON item;

BGRANT SELECT ON item TO public;

CREVOKE 'r' ON item TO public;

DREVOKE READ ON item TO public;

EREVOKE public SELECT ON item;

Show Suggested Answer

Suggested Answer: A

by Eun at Mar 20, 2023, 08:40 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Noble

1 months ago

Is option B the right answer? If not, I'll have to 'item-ize' my study notes again.

upvoted 0 times

Kristine

3 days ago

C) REVOKE 'r' ON item TO public;

upvoted 0 times

...

Jesusita

21 days ago

B) GRANT SELECT ON item TO public;

upvoted 0 times

...

Skye

22 days ago

A) GRANT public SELECT ON item;

upvoted 0 times

...

Gerald

1 months ago

E is just the opposite of what we want to do. We need to grant, not revoke, the SELECT privilege.

upvoted 0 times

Vernice

9 days ago

D) REVOKE READ ON item TO public;

upvoted 0 times

...

Tess

23 days ago

C) REVOKE 'r' ON item TO public;

upvoted 0 times

...

Linsey

28 days ago

B) GRANT SELECT ON item TO public;

upvoted 0 times

...

Justine

29 days ago

A) GRANT public SELECT ON item;

upvoted 0 times

...

Ramonita

2 months ago

Haha, 'C' and 'D' are clearly wrong. REVOKE 'r'? What is this, a pirate database?

upvoted 0 times

Mollie

19 days ago

Haha, 'C' and 'D' are clearly wrong. REVOKE 'r'? What is this, a pirate database?

upvoted 0 times

...

Lindsey

22 days ago

B) GRANT SELECT ON item TO public;

upvoted 0 times

...

Lisha

1 months ago

A) GRANT public SELECT ON item;

upvoted 0 times

...

Otis

2 months ago

I was torn between options A and B, but B seems more precise in granting the SELECT privilege to the public.

upvoted 0 times

Wade

20 days ago

User1: Let's go with option B then.

upvoted 0 times

...

Tamar

21 days ago

User3: Yeah, option A seems a bit off.

upvoted 0 times

...

Emily

28 days ago

User2: I agree, option B grants SELECT on item to public.

upvoted 0 times

...

Stanton

1 months ago

User1: I think option B is the correct one.

upvoted 0 times

...

Winifred

2 months ago

I think option B is the correct answer. It grants the SELECT privilege to the public role on the 'item' table.

upvoted 0 times

...

Sena

2 months ago

I'm not sure, but I think option A) GRANT public SELECT ON item; could also be correct.

upvoted 0 times

...

Genevieve

2 months ago

I agree with Luis, because we want to grant the SELECT permission to the public group.

upvoted 0 times

...

Luis

2 months ago

I think the correct answer is B) GRANT SELECT ON item TO public.

upvoted 0 times

...