Discuss PostgreSQL PGCES-02 Exam Topic 2 Question 41

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;

Suggested Answer: A

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

41 comments · newest first

Kathrine 11 months ago

I agree with B, but I thought public was a reserved keyword?

Craig 11 months ago

Wait, are we sure about B? Seems too simple.

Thaddeus 12 months ago

C and D are just wrong, no way those work.

Kami 12 months ago

I think A is also valid, but B is clearer.

Lonny 12 months ago

Definitely B, that's the correct syntax!

Michell 1 year ago

I'm pretty confident that C and D are definitely wrong since they involve REVOKE, which isn't what we want here.

Cecily 1 year ago

I feel like A could be right too, but I don't recall if "public" is the right keyword in this context.

Carissa 1 year ago

I remember practicing a similar question, and I believe "GRANT SELECT ON item TO public;" is the standard way to give permissions.

Alisha 1 year ago

I think the correct answer might be B, but I'm not entirely sure if "TO public" is necessary.

Ahmed 1 year ago

Got it, I think option C is the correct answer. The client PC's IP is in the same 192.168.2.0/24 subnet as the router's local IP, and the gateway is set to the router's local IP.

Lashaunda 1 year ago

Okay, I think I've got this. The payment system they're describing sounds like the Ambulatory Payment Classification (APC) system used by CMS for outpatient services. That shifts the risk to the provider through a fixed-fee approach.

An 1 year ago

Hmm, the unique stack of dependencies is the key detail here. I'm leaning towards PaaS to handle that complexity.

Tonja 1 year ago

This reminds me of a practice question we did that mentioned multiple business processes. I might lean towards false.

Lauryn 1 year ago

Okay, let me think this through step-by-step. We have the equipment's net carrying amount, tax basis, removal cost, and scrap value. I think I can use those to calculate the appropriate end-of-life cash flow.

Audra 1 year ago

Hmm, I'm a bit unsure about this one. I know URL filtering is important for security, but I'm not totally clear on the specific benefits of implementing it on the Cisco ESA. I'll have to think this through carefully.

Noble 1 year ago

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

Kristine 1 year ago

↳ replying to Noble

C) REVOKE 'r' ON item TO public;

Jesusita 1 year ago

↳ replying to Noble

B) GRANT SELECT ON item TO public;

Skye 1 year ago

↳ replying to Noble

A) GRANT public SELECT ON item;

Gerald 1 year ago

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

Graciela 1 year ago

↳ replying to Gerald

B) GRANT SELECT ON item TO public;

Delisa 1 year ago

↳ replying to Gerald

A is the correct statement to grant SELECT privilege to all users.

Sunny 1 year ago

↳ replying to Gerald

B) GRANT SELECT ON item TO public;

Thersa 1 year ago

↳ replying to Gerald

A) GRANT public SELECT ON item;

Vernice 1 year ago

↳ replying to Gerald

D) REVOKE READ ON item TO public;

Tess 1 year ago

↳ replying to Gerald

C) REVOKE 'r' ON item TO public;

Linsey 1 year ago

↳ replying to Gerald

B) GRANT SELECT ON item TO public;

Justine 1 year ago

↳ replying to Gerald

A) GRANT public SELECT ON item;

Ramonita 1 year ago

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

Mollie 1 year ago

↳ replying to Ramonita

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

Lindsey 1 year ago

↳ replying to Ramonita

B) GRANT SELECT ON item TO public;

Lisha 1 year ago

↳ replying to Ramonita

A) GRANT public SELECT ON item;

Otis 2 years ago

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

Wade 1 year ago

↳ replying to Otis

User1: Let's go with option B then.

Tamar 1 year ago

↳ replying to Otis

User3: Yeah, option A seems a bit off.

Emily 1 year ago

↳ replying to Otis

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

Stanton 1 year ago

↳ replying to Otis

User1: I think option B is the correct one.

Winifred 2 years ago

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

Sena 2 years ago

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

Genevieve 2 years ago

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

Luis 2 years ago

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

PostgreSQL PGCES-02 Exam - Topic 2 Question 41 Discussion