PostgreSQL_CE
PGCES-02 · Question #11
PGCES-02 Question #11: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #11. The question stem and answer options stay visible for context.
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.
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.