nerdexam
PostgreSQL_CE

PGCES-02 · Question #11

Select one incorrect description regarding the following SQL statement defining a function. CREATE OR REPLACE FUNCTION get_file_list(TEXT, BOOLEAN) RETURNS SETOF TEXT LANGUAGE C STRICT SECURITY…

The correct answer is E. This functionoperates with the authority of the user who executed it. See the full explanation below for the reasoning.

Question

Select one incorrect description regarding the following SQL statement defining a function. CREATE OR REPLACE FUNCTION get_file_list(TEXT, BOOLEAN) RETURNS SETOF TEXT LANGUAGE C STRICT SECURITY DEFINER AS 'myfuncs.so'; PostgreSQL CE PGCES-02 Exam

Options

  • AThis function may bedefined in 'myfuncs.so'.
  • BThis function can return multiple rows.
  • CThis SQL statementdefines a function written in the C language.
  • DIf this function is called with a NULL parameter, it will return 0 when executed.
  • EThis functionoperates with the authority of the user who executed it.

How the community answered

(23 responses)
  • A
    13% (3)
  • C
    4% (1)
  • D
    9% (2)
  • E
    74% (17)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PGCES-02 Practice