PostgreSQL_CE
PGCES-02 · Question #95
The following is the result of executing the createlang command which is installed with PostgreSQL. $ createlang -U postgres --list mydb Procedural Languages Name | Trusted? ---------+…
The correct answer is B. The procedural languageplpgsql can be used in the database mydb. E. plpgsql is a safe language with restricted operations. See the full explanation below for the reasoning.
Question
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.
Options
- AThe procedural languageplpgsql is installed in the database mydb using the above command.
- BThe procedural languageplpgsql can be used in the database mydb.
- Cplpgsql is a trusted language, so it can execute the OS commands on the server side.
- Dplpgsql is a trusted language, so it can read/write OS files on the server side.
- Eplpgsql is a safe language with restricted operations.
How the community answered
(18 responses)- A6% (1)
- B78% (14)
- C6% (1)
- D11% (2)
Community Discussion
No community discussion yet for this question.