Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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.

Show Suggested Answer Hide 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
3 months ago
Is option B the right answer? If not, I'll have to 'item-ize' my study notes again.
upvoted 0 times
Kristine
2 months ago
C) REVOKE 'r' ON item TO public;
upvoted 0 times
...
Jesusita
2 months ago
B) GRANT SELECT ON item TO public;
upvoted 0 times
...
Skye
2 months ago
A) GRANT public SELECT ON item;
upvoted 0 times
...
...
Gerald
3 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
Graciela
24 days ago
B) GRANT SELECT ON item TO public;
upvoted 0 times
...
Delisa
25 days ago
A is the correct statement to grant SELECT privilege to all users.
upvoted 0 times
...
Sunny
1 months ago
B) GRANT SELECT ON item TO public;
upvoted 0 times
...
Thersa
1 months ago
A) GRANT public SELECT ON item;
upvoted 0 times
...
Vernice
2 months ago
D) REVOKE READ ON item TO public;
upvoted 0 times
...
Tess
2 months ago
C) REVOKE 'r' ON item TO public;
upvoted 0 times
...
Linsey
2 months ago
B) GRANT SELECT ON item TO public;
upvoted 0 times
...
Justine
2 months ago
A) GRANT public SELECT ON item;
upvoted 0 times
...
...
Ramonita
3 months ago
Haha, 'C' and 'D' are clearly wrong. REVOKE 'r'? What is this, a pirate database?
upvoted 0 times
Mollie
2 months ago
Haha, 'C' and 'D' are clearly wrong. REVOKE 'r'? What is this, a pirate database?
upvoted 0 times
...
Lindsey
2 months ago
B) GRANT SELECT ON item TO public;
upvoted 0 times
...
Lisha
3 months ago
A) GRANT public SELECT ON item;
upvoted 0 times
...
...
Otis
3 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
2 months ago
User1: Let's go with option B then.
upvoted 0 times
...
Tamar
2 months ago
User3: Yeah, option A seems a bit off.
upvoted 0 times
...
Emily
2 months ago
User2: I agree, option B grants SELECT on item to public.
upvoted 0 times
...
Stanton
3 months ago
User1: I think option B is the correct one.
upvoted 0 times
...
...
Winifred
3 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
3 months ago
I'm not sure, but I think option A) GRANT public SELECT ON item; could also be correct.
upvoted 0 times
...
Genevieve
3 months ago
I agree with Luis, because we want to grant the SELECT permission to the public group.
upvoted 0 times
...
Luis
3 months ago
I think the correct answer is B) GRANT SELECT ON item TO public.
upvoted 0 times
...

Save Cancel