PostgreSQL Exam PGCES-02 Topic 11 Question 38 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 38
Topic #: 11

A table is defined as follows: CREATE TABLE t (id INT, val TEXT); Select two correct statements from below about the function "get_head" defined below. CREATE

FUNCTION get_head(BOOLEAN) RETURNS TEXT LANGUAGE sql CALLED ON

NULL INPUT AS 'SELECT val FROM t WHERE $1 OR id > 0 ORDER BY id LIMIT 1;';

AThis function is defined using PL/pgSQL.

BThere are cases where this function returns multiple lines.

CWhen NULL is passed for the argument and the function is executed, NULL is returned.

DEven if this function is passed the same parameter value and executed multiple times, the returned values will not necessarily also be the same value.

EIf a function with the same name and with type BOOLEAN as the parameter is already defined, an error occurs.

Show Suggested Answer

Suggested Answer: A, D

by Devorah at Jan 09, 2023, 01:14 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!