MENU
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.
Suggested Answer: B, E
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
17 comments · newest first
TA
Talia
23 days ago
Yes, A and E are the best options!
MA
Mable
28 days ago
So, A and E then?
CH
Charlene
1 month ago
Exactly! E is a good choice too.
TH
Thad
1 month ago
E makes sense. It's safe with restrictions.
TA
Talia
1 month ago
Right, C is wrong. D is also incorrect.
MA
Mable
2 months ago
C is misleading. plpgsql can't execute OS commands.
CH
Charlene
2 months ago
Agreed! A confirms installation, B allows usage.
TH
Thad
2 months ago
I think A and B are correct.
AL
Allene
2 months ago
E) is spot on, plpgsql has its limits for safety!
AL
Alexia
2 months ago
C) is misleading, it can't just run any OS command.
ST
Starr
2 months ago
Wait, is plpgsql really trusted? That seems risky.
MI
Micah
3 months ago
Totally agree, plpgsql is super useful!
RE
Reena
3 months ago
A) and B) are correct.
LE
Lewis
3 months 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.
TH
Theodora
3 months ago
I feel like C and D might be tricky; I thought trusted languages could do more, but I can't recall the specifics.
SO
Sommer
3 months ago
I'm not entirely sure, but I think B is also right since the command shows plpgsql is listed for mydb.
SC
Scot
4 months ago
I remember that plpgsql is indeed installed in the database when using createlang, so A seems correct.