Select two appropriate statements from below about the following SQL statements:

CREATE FUNCTION myfunc(INTEGER) RETURNS text LANGUAGE plpgsql STRICT AS ' DECLARE x ALIAS FOR $1; r text := ''default''; BEGIN IF x > 100 THEN SELECT INTO r data FROM mytable WHERE id = x; END IF; RETURN r; END;';

Question

Select two appropriate statements from below about the following SQL statements:

CREATE FUNCTION myfunc(INTEGER) RETURNS text LANGUAGE plpgsql STRICT AS ' DECLARE x ALIAS FOR $1; r text := ''default''; BEGIN IF x > 100 THEN SELECT INTO r data FROM mytable WHERE id = x; END IF; RETURN r; END;';

Accepted Answer

A. An error is generated unless theplpgsql language is registered in the database beforehand. E. When SELECTmyfunc (0) is executed the text "default" is returned.

Answer

B. The execution results of SELECTmyfunc(-123) differs based on the content of "mytable".

Answer

C. When SELECTmyfunc(123) is executed an error occurs.

Answer

D. When SELECTmyfunc(NULL) is executed an error occurs.

Select two appropriate statements from below about the following SQL statements: CREATE FUNCTION myfunc(INTEGER) RETURNS text LANGUAGE plpgsql STRICT AS ' DECLARE x ALIAS FOR $1; r text :=…

Question

Options

How the community answered

Community Discussion