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 PGCES-02 Exam - Topic 5 Question 94 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 94
Topic #: 5
[All PGCES-02 Questions]

The following is the result of executing the createlang command which is installed with

PostgreSQL. $ createlang -U postgres --list mydb Procedural Languages Name |

Trusted?

---------+---------plpgsql | yes Select two correct statements from below.

Show Suggested Answer Hide Answer
Suggested Answer: B, E

by Ettie at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Glory
24 hours ago
D) I don't think that's right, plpgsql can't just read/write files.
upvoted 0 times
...
Gracia
6 days ago
C) wait, can it really execute OS commands?
upvoted 0 times
...
Lino
11 days ago
B) for sure, plpgsql is ready to go!
upvoted 0 times
...
Veronica
16 days ago
A) is definitely correct.
upvoted 0 times
...
Roxanne
22 days ago
Ah, the joys of trusted languages and server-side file access. What could possibly go wrong?
upvoted 0 times
...
Dorathy
27 days ago
B and E seem like the most reasonable options here.
upvoted 0 times
...
Leonora
2 months ago
Definitely B and C. I can't wait to run some OS commands on the server!
upvoted 0 times
...
Margot
2 months ago
I think B and D are the right answers. Who needs file access anyway?
upvoted 0 times
...
Rossana
2 months ago
B and E are correct.
upvoted 0 times
...
Nelida
2 months ago
I feel like E is also correct because I learned that plpgsql has some restrictions compared to untrusted languages.
upvoted 0 times
...
Lajuana
2 months ago
I practiced a similar question, and I think B is definitely true since plpgsql is installed and can be used in mydb.
upvoted 0 times
...
Karima
2 months ago
I'm a bit unsure about C and D; I thought trusted languages could do more, but I can't recall the specifics.
upvoted 0 times
...
Nan
3 months ago
I remember that plpgsql is indeed installed in the database when using the createlang command, so A seems correct.
upvoted 0 times
...
Dominque
3 months ago
Based on my understanding, plpgsql is a safe, restricted language, so option E is also correct. I'll select A, B, and E for my final answer.
upvoted 0 times
...
Carey
3 months ago
I'm not sure about the trusted language part. Does that mean plpgsql can execute OS commands or read/write files? I'll have to double-check that.
upvoted 0 times
...
Michal
3 months ago
Okay, I've got it. The createlang command lists the available procedural languages, and plpgsql is one of them. So options A and B must be correct.
upvoted 0 times
...
Carey
3 months ago
I'm a bit confused by the question. Does the createlang command install the plpgsql language or just list the available languages? I'll need to think this through.
upvoted 0 times
...
Deane
3 months ago
Hmm, this seems straightforward. I'll start by carefully reading through the options and thinking about what the createlang command does.
upvoted 0 times
...

Save Cancel