PostgreSQL PGCES-02 Exam - Topic 10 Question 102 Discussion

Question

PostgreSQL PGCES-02 Exam - Topic 10 Question 102 Discussion

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';

A) This function may be defined in 'myfuncs.so'.

B) This function can return multiple rows.

C) This SQL statement defines a function written in the C language.

D) If this function is called with a NULL parameter, it will return 0 when executed.

Accepted Answer

E) This function operates with the authority of the user who executed it.

PostgreSQL PGCES-02 Exam - Topic 10 Question 102 Discussion

PostgreSQL PGCES-02 Exam - Topic 10 Question 102 Discussion

Contribute your Thoughts: