PGCES-02 practice question 4 of 10

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

Full set: 142 questions
Answer options
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.
E: This function operates with the authority of the user who executed it.
Correct Answer:
Scroll to Top