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 2 Question 101 Discussion

The following is the result of executing the createlang command which is installed withPostgreSQL. $ createlang -U postgres --list mydb Procedural Languages Name |Trusted?---------+---------plpgsql | yes Select two correct statements from below.
B) The procedural language plpgsql can be used in the database mydb. and E) plpgsql is a safe language with restricted operations.
A) The procedural language plpgsql is installed in the database mydb using the above command.
C) plpgsql is a trusted language, so it can execute the OS commands on the server side.
D) plpgsql is a trusted language, so it can read/write OS files on the server side.

PostgreSQL PGCES-02 Exam - Topic 2 Question 101 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 101
Topic #: 2
[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 Elvis at May 30, 2026, 07:25 PM

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
Lewis
7 hours ago
I think E is definitely true because plpgsql is designed to be safe, but I need to double-check the definitions of trusted vs. safe.
upvoted 0 times
...
Theodora
5 days ago
I feel like C and D might be tricky; I thought trusted languages could do more, but I can't recall the specifics.
upvoted 0 times
...
Sommer
11 days ago
I'm not entirely sure, but I think B is also right since the command shows plpgsql is listed for mydb.
upvoted 0 times
...
Scot
16 days ago
I remember that plpgsql is indeed installed in the database when using createlang, so A seems correct.
upvoted 0 times
...

Save Cancel