New Year Sale 2026! 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
Leonora
3 days ago
Definitely B and C. I can't wait to run some OS commands on the server!
upvoted 0 times
...
Margot
8 days ago
I think B and D are the right answers. Who needs file access anyway?
upvoted 0 times
...
Rossana
13 days ago
B and E are correct.
upvoted 0 times
...
Nelida
18 days ago
I feel like E is also correct because I learned that plpgsql has some restrictions compared to untrusted languages.
upvoted 0 times
...
Lajuana
23 days 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
29 days 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
1 month ago
I remember that plpgsql is indeed installed in the database when using the createlang command, so A seems correct.
upvoted 0 times
...
Dominque
1 month 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
1 month 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
2 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
2 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
2 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