nerdexam
PostgreSQL_CE

PGCES-02 · Question #95

PGCES-02 Question #95: Real Exam Question with Answer & Explanation

Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.

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.

Unlock PGCES-02 to see the answer

You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full PGCES-02 Practice